Registered aircraft · 54,015

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.

N8570QTwo O Six Inc · Fort Myers, FLBuilt 1976 · S/N U20603426 N8570THeuett Clint James · Asotin, WABuilt 1959 · S/N 52470 N8571JRoam Gary A · Venice, FLBuilt 1967 · S/N 15066471 N8571SStevenson Intermountain Seed Inc · Ephraim, UTBuilt 1965 · S/N 18256671 N8571UBell Charles M DBA · Warsaw, NYBuilt 1965 · S/N 17252471 N8571XRegistered aircraftBuilt 1963 · S/N P17257171 N8572RReese Owein · Glen Rock, NJBuilt 1964 · S/N 205-0549 N8572SPaulan Beverly S · Antioch, ILBuilt 1965 · S/N 18256672 N8572TAerial Wayfarer LLC · San Antonio, TXS/N 52472 N8572USkyline Aviation Solutions LLC · Grosse Ile, MIBuilt 1976 · S/N 15077952 N8573GFichtner Eric Lowell Russell · Concord, NCS/N 15062673 N8573S182 Flight Corp · Bronx, NYBuilt 1965 · S/N 18256673 N8574JHubenthal William L · Carbondale, ILBuilt 1967 · S/N 15066474 N8574XDiscover Aviation Center LLC · Elyria, OHBuilt 1963 · S/N P17257174 N8575GAero Services Lc · Woods Cross, UTS/N 15062675 N8575SDallas William J · Eastsound, WABuilt 1965 · S/N 18256675 N8575TChristensen Del S Trustee · Friendswood, TXBuilt 1959 · S/N 52475 N8575UVermillion County Flying Club · Danville, ILBuilt 1965 · S/N 17252475 N8576BRomeo Delta Inc · Elsie, MIBuilt 1957 · S/N 36276 N8576GSchaefer John · Liberty Hill, TXBuilt 1966 · S/N 15062676 N8576QThompson Robert Lee · Moore, OKBuilt 1976 · S/N U20603432 N8577GLakey Robert E · Arlington, TXBuilt 1965 · S/N 15062677 N8577SRegistration Pending · Concord, GARegistration pendingBuilt 1965 · S/N 18256677 N8578JParagon Aviation LLC · Reading, PABuilt 1967 · S/N 15066478 N8579SHopp Gregory R · Columbus, OHBuilt 1965 · S/N 18256679 N8579TGoldschmidt Scott · Cottonwood, CABuilt 1960 · S/N 52479 N8579UStueckradt Steve · Ankeny, IABuilt 1965 · S/N 17252479 N857DKKnight Kevin · Dallas, TXBuilt 1983 · S/N R18201935 N857ERAlpha International Aircraft Inc · Lewes, DES/N 15282420 N8580BB&R Aircraft LLC · Wadsworth, OHBuilt 1958 · S/N 36280 N8580GRhoat William E · Paso Robles, CAFirst renewal noticeBuilt 1965 · S/N 15062680 N8580QBald Eagle Aviation LLC · Oakley, UTBuilt 1976 · S/N U20603436 N8580TBas Part Sales LLC · Greeley, COBuilt 1960 · S/N 52480 N8580UBaker Shane A · Marshall, WIBuilt 1965 · S/N 17252480 N8581FAccurate Aero LLC · Minden, NVS/N 51956 N8581SBlack Samuel W · Kennesaw, GABuilt 1965 · S/N 18256681 N8581ULarkin John · Cambridge, IDBuilt 1965 · S/N 17252481 N8581XRegistered aircraftBuilt 1963 · S/N P17257181 N8582BHousley William M · Jasper, ALS/N 36282 N8582JMarchione Laverne R · Diamondville, WYBuilt 1967 · S/N 15066482 N8582UMartin Livestock LLC · Ione, CABuilt 1965 · S/N 17252482 N8583SDevillier Roland James · Winnie, TXBuilt 1965 · S/N 18256683 N8583UVon Burg Jon B · Hull, ILS/N 17252483 N8584JDarrach Todd I · Rhome, TXBuilt 1967 · S/N 15066484 N8584SRider Richard Trustee · Mill Valley, CABuilt 1965 · S/N 18256684 N8584UPlane View Portraits LLC · Wolverine Lake, MIBuilt 1966 · S/N 18257756 N8584VIdk Ventures LLC · Olympia, WABuilt 1965 · S/N 17252484 N8585GCollins Terry R · Lewistown, ILBuilt 1965 · S/N 15062685 N8585SPreszler Terry J · Richland, WABuilt 1965 · S/N 18256685 N8585THancock Jeff · Jacksonville, TXBuilt 1959 · S/N 52485

Back to AD 87-20-03 R2