Registered aircraft · 54,017

Registered aircraft whose airframe or engine model this AD names, by N-number. Matched by model only, so check each against the AD’s applicability.

Query with SQL

SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:87-20-03-R2') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-20-03-R2') ORDER BY n_number

duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
  FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
  WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:87-20-03-R2')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-20-03-R2')
  ORDER BY n_number"

Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.

SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:87-20-03-R2')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-20-03-R2')
ORDER BY n_number

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

N4962BUniversity Of Maryland Eastern Shore · Princess Anne, MDBuilt 1979 · S/N 15283726 N4962DMcdonald Richard Reid · Rock Island, WAS/N 51062 N4962FEvans Dick G Trustee · Riverside, CABuilt 1966 · S/N U206-0662 N4962GVersteeg Martin · San Antonio, TXBuilt 1979 · S/N 17273509 N4962HKelly William W · Springfield, ORBuilt 1979 · S/N 15284047 N4962LCypret Phillip B · Sacramento, CABuilt 1980 · S/N 15284246 N4962VAircraft Partner Holdings Inc Trustee · BerlinBuilt 1980 · S/N 172RG0430 N4963GSunwest Aviation Inc · Santa Ynez, CABuilt 1979 · S/N 17273510 N4963NHarrison Earl S · Clarksville, TNBuilt 1979 · S/N 18267485 N4963UAllen Shanda · Aynor, SCBuilt 1965 · S/N 21058663 N49649C & T Aviation Holdings Inc · Mckinney, TXBuilt 1979 · S/N 15283488 N4964AThree Sisters Capital LLC · Visalia, CABuilt 1956 · S/N 32361 N4964DGrizzly Air Service Inc · Paris, TXBuilt 1958 · S/N 51064 N4964FTeam Builders Inc · Carson City, NVBuilt 1966 · S/N U206-0664 N4964GCrotts Aircraft Service Inc · Dodge City, KSBuilt 1979 · S/N 17273511 N4964PGregory Kristen · Vallejo, CABuilt 1981 · S/N 15284862 N49654Herman Brian · Clarksdale, AZBuilt 1979 · S/N 15283491 N4965ADks Air LLC · Owasso, OKS/N P21000827 N4965NDowner Michael · Scottsdale, AZBuilt 1979 · S/N 18267487 N4966E4966e LLC · Kalispell, MTBuilt 1956 · S/N 33000 N4966GSonger Charles W III · Tuscaloosa, ALBuilt 1979 · S/N 17273513 N4966SMonkey Butler LLC · Pacifica, CABuilt 1980 · S/N R18201495 N4967BUniv Of Illinois Bd Of Trustees · Savoy, ILBuilt 1979 · S/N 15283730 N4967DSchmieding Michael A · Salem, ORBuilt 1958 · S/N 51067 N4967FMile Hi Skydivers Inc · Longmont, COBuilt 1966 · S/N U206-0667 N4967KBrown Lawson M II DBA · San Diego, CABuilt 1979 · S/N P21000386 N49681Sunwest Aviation Inc · Santa Ynez, CAFirst renewal noticeBuilt 1979 · S/N 15283495 N4968AD&B Aircraft Leasing LLC · Anchorage, AKBuilt 1956 · S/N 32365 N4968DNelson Scott D · Blackfoot, IDBuilt 1958 · S/N 51068 N4968NConfarotta Todd A · Mount Pleasant, SCBuilt 1979 · S/N 18267489 N4968PDuncan Arnold A · Bozeman, MTBuilt 1981 · S/N 15284863 N4968UGreen Brandon K · Eufaula, ALBuilt 1965 · S/N 21058668 N49696Stoffer Aviation LLC · Marion, INS/N 15283496 N4969DFarwick Kobbe L · Lenexa, KSS/N 51069 N4969ECapricorn Equipment Co · Madisonville, KYBuilt 1978 · S/N 17271685 N4969GSanford Aircraft LLC · Winter Springs, FLBuilt 1979 · S/N 17273516 N4969NGreen Michael P · Thomaston, CTBuilt 1979 · S/N 18267490 N4969RUnited States Air Force Owner · Offutt Afb, NEBuilt 1967 · S/N 17256323 N4969UTallgrass Aviation LLC · Sharon Springs, KSBuilt 1965 · S/N 21058669 N496HMTalon Air Service Inc · Soldotna, AKBuilt 1976 · S/N 17267496 N4970ANervino David J · Hilmar, CABuilt 1956 · S/N 32367 N4970DMayes Nicholas R · Williams, CABuilt 1958 · S/N 51070 N4970QPettis Ag Aviation LLC · Atlantic, IABuilt 1976 · S/N 18802704T N49710Peshak Blair Keith · Georgetown, TXS/N 15283498 N4971ATruman Sparks Aviation LLC · Wink, TXBuilt 1956 · S/N 32368 N4971DBolin William E · Smithville, OHBuilt 1958 · S/N 51071 N4971FRegistration Pending · Cottonwood, CARegistration pendingBuilt 1979 · S/N 17273110 N4971GSuper Hawk Inc · West Jordan, UTBuilt 1979 · S/N 17273518 N4971RScherer Sid S · Napa, CABuilt 1967 · S/N 17256325 N4971VGorman John Scott · Homosassa, FLBuilt 1980 · S/N 172RG0436

Back to AD 87-20-03 R2