Registered aircraft · 68,369

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:90-04-06-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:90-04-06-R1') 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:90-04-06-R1')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:90-04-06-R1')
  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:90-04-06-R1')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:90-04-06-R1')
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.

N177BDHillsboro Aero Academy LLC · Hillsboro, ORBuilt 1978 · S/N 15281660 N177BGAccurso Steven M · Marietta, GAS/N 17702449 N177BHAircraft Trade Group LLC · Scandia, MNS/N 17701411 N177BLMontgomery David · Oak Park, ILBuilt 1976 · S/N 17702425 N177BSWilliams James E · Kirkwood, MOBuilt 1978 · S/N 177RG1017 N177BTPlane Data Inc · Terrell, NCBuilt 1977 · S/N 177RG1194 N177BVGhostrider Aviation Inc · Bohemia, NYS/N 177RG1288 N177BWRegistered aircraftBuilt 1972 · S/N 17701756 N177BZZotter Brand LLC · Vero Beach, FLBuilt 1971 · S/N 177RG0058 N177CCHoel Martin J · Waterloo, IABuilt 1967 · S/N 17700654 N177CELedley Charles F · Pasadena, MDBuilt 1978 · S/N 177RG1308 N177CJCuneo Christopher G · Jupiter, FLBuilt 1970 · S/N 177RG0018 N177CTLancaster Clinton · Gainesville, FLS/N AA1C-0016 N177CVZinkel Gregory S · Leander, TXS/N 17700640 N177DBarger Randall G · Newport News, VABuilt 1973 · S/N 17702012 N177DAParry Thomas J · White Post, VABuilt 1977 · S/N 17702617 N177DCBastian Justin Paul · Chubbuck, IDBuilt 1973 · S/N 177RG0335 N177DKKeen David S · Amherst, NHBuilt 1967 · S/N 17700567 N177DPPerkins Dimmitt J · Sheridan, ARBuilt 1976 · S/N 02 N177DWJones Stephen L · Cypress, TXBuilt 1973 · S/N 177RG0338 N177EBDodd Lisa · Sandpoint, IDBuilt 1967 · S/N 17700562 N177EELiebeler Susan Trustee · Malibu, CABuilt 1976 · S/N 17702511 N177EFCivitarese Nicholas G · Furlong, PABuilt 1976 · S/N 177RG1008 N177EJDouble A Flight Services LLC · Edinburg, TXBuilt 1971 · S/N 17701626 N177ETThorstad Aviation LLC · Alexandria, MNBuilt 1976 · S/N 17702378 N177EWMidwest Bush Co LLC · New Strawn, KSBuilt 1996 · S/N 23177 N177FBBosse Frederick C · Myrtle Beach, SCBuilt 1978 · S/N 177RG1322 N177FDSale Reported · Bowling Green, KYSale reportedBuilt 1967 · S/N 680040 N177FGMancini Joseph · Alpine, CABuilt 1968 · S/N 17700817 N177FHSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1976 · S/N 177RG1034 N177FJInternational Air Services Inc Trustee · Carson City, NVBuilt 1974 · S/N 17702122 N177FRLandrum David W · Hot Springs, ARBuilt 1974 · S/N 17702135 N177GAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1978 · S/N 177RG1355 N177GBHess Robert E · Rockford, ILBuilt 1975 · S/N AA5B-0123 N177GLRegistration Pending · Las Vegas, NVRegistration pendingBuilt 1974 · S/N 17702177 N177GSAvco Patrol LLC · Lyndon, KSBuilt 1972 · S/N 17701845 N177GTWoischke Robert B · Schaumburg, ILBuilt 1973 · S/N 17702052 N177GWMarquette County Flying Club · Marquette, MIBuilt 1976 · S/N 17702481 N177HHaman Aviation Services LLC · Nokomis, FLBuilt 1973 · S/N 177RG0336 N177HLLuken Henry G III · Chattanooga, TNS/N 17701106 N177HWCentral Virginia Aviation Inc · Petersburg, VAS/N 17701482 N177JAFrye Richard E Trustee · Kennewick, WAFirst renewal noticeBuilt 1977 · S/N 177RG1278 N177JCChorvat Stanley James II · Brooksville, FLBuilt 1977 · S/N 177RG1156 N177JFIsr Aviation LLC · Wilmington, DEBuilt 1975 · S/N 17702259 N177JGHenderson James E · Greenville, TXBuilt 1975 · S/N 177RG0725 N177JJJ P Jaeger Farms LLC · Imperial, NEBuilt 1975 · S/N 17702314 N177JKRutsch Kirk A · Lewes, DEBuilt 1972 · S/N 17701828 N177JLRisko Michael Robert · Sturgis, MIBuilt 1977 · S/N 17702713 N177JMWright Alan L · Independence, ORBuilt 1968 · S/N 17701307 N177JRIntelliray Inc · Decatur, INBuilt 1970 · S/N 17701481

Back to AD 90-04-06 R1