Registered aircraft · 54,019

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.

N1399MRegistered aircraftBuilt 1975 · S/N 18264314 N1399SDesmond Brett Kyle · Mars, PABuilt 1976 · S/N 18264960 N1399UOc 172 Group LLC · Costa Mesa, CAFirst renewal noticeBuilt 1976 · S/N 17267070 N139ARSky West Aviation Inc Trustee · Albuquerque, NMS/N 25557 N139BBTrejo Nahomy · Socorro, TXBuilt 1979 · S/N 21063712 N139BTTaylor Edward S · Billings, MTBuilt 1957 · S/N 29707 N139ERRick Aviation Inc · Newport News, VABuilt 1985 · S/N 17276532 N13BALong Arthur · Colonie, NYBuilt 1975 · S/N 15077300 N13BJSevcik Clint · Medford, MNS/N 21058486 N13CBT&W Aviation LLC · Pinehurst, TXBuilt 1981 · S/N 17274805 N13DRSchuler Edward A Jr · Hamden, CTFirst renewal noticeBuilt 1966 · S/N 15064816 N13DSR & M Adventures LLC · Wichita, KSBuilt 1980 · S/N 18267798 N13EAHood Norman R · Austin, TXBuilt 1977 · S/N 15279914 N13EFMcgough Julie Eileen · Red Oak, TXBuilt 1967 · S/N 337-0794 N13FGBaum Group LLC · Shavertown, PABuilt 1957 · S/N 34271 N13FTFenix Private Capital Group LLC · Phoenix, AZS/N P3370245 N13HKSkycombers Flying Club Inc · Pacoima, CABuilt 1972 · S/N 17701810 N13HWSikes Alan · Collins, GABuilt 1962 · S/N 1850290 N13JTHoltzclaw Timothy M · O Brien, FLBuilt 1972 · S/N 17261008 N13KKSanders Flight Training Center Inc · Jasper, ALBuilt 1977 · S/N 17268760 N13KSNolt Ivan · Mount Solon, VABuilt 1974 · S/N 21060202 N13MCMathison Neil James · Solon Springs, WIBuilt 1974 · S/N 18052444 N13NPEvans Randall B Trustee · Fallon, NVBuilt 1954 · S/N 31225 N13SKFlydreams Aircraft Group Inc · Fort Lauderdale, FLBuilt 1978 · S/N 17271183 N13SPNew York State Police · Latham, NYBuilt 1967 · S/N 17256431 N13TATextron Aviation Inc · Wichita, KSS/N 17276111 N13TNMcdaniel Robert M · Tonasket, WABuilt 1977 · S/N 21062428 N13TPLehman Aviation LLC · Remington, INBuilt 1976 · S/N 17267454 N13WSJohnson Chad H · Houston, TXBuilt 1979 · S/N 18503938 N13WTBentz George T · Missoula, MTBuilt 1973 · S/N 18262089 N13WWHurd Steven C · Bangor, MEBuilt 1982 · S/N 18504378 N13YPBlock Scott M · Chandler, AZBuilt 1968 · S/N 17257055 N1400Salour Michael M · Carlsbad, CABuilt 1979 · S/N P210-00277 N1400FBingham Edward K · Buchanan, GABuilt 1966 · S/N 17254895 N1400UTino Frank V Jr · Miami, FLBuilt 1960 · S/N 15059024 N1401Prestonlines LLC · Wilmington, DEBuilt 1950 · S/N 7540 N1401DRegistered aircraftBuilt 1951 · S/N 19984 N1401EUnited States Air Force Aero Club · Usaf Academy, COBuilt 1978 · S/N 17270986 N1402FRegistration Pending · Pomona, CARegistration pendingBuilt 1966 · S/N 17254897 N1402SJohnston Matthew A · Ventura, CABuilt 1976 · S/N 18264962 N1402YRg Enterprises LLC · Tullahoma, TNBuilt 1961 · S/N 17249102 N1403FGoedeker Jr Werner F · Waterville, NYBuilt 1966 · S/N 17254898 N1403SFarnsworth Scott · Crestwood, KYBuilt 1976 · S/N 18264963 N1403VSmith Dennis A Trustee · Salem, ORBuilt 1974 · S/N 17263550 N1404CAeroscalper LLC · Goshen, INBuilt 1977 · S/N 17702721 N1404SRegistration Pending · Englewood, CORegistration pendingS/N 18264964 N14055Top Hand Inc · Laurel, MTBuilt 1952 · S/N 20937 N1405MWilson George W · Tucson, AZBuilt 1975 · S/N 18264318 N1405SVickers David A · Douglas, GABuilt 1976 · S/N 18264965 N1405UGuardian Aerial Patrol LLC · Edmond, OKBuilt 1976 · S/N 17267075

Back to AD 87-20-03 R2