Skip to content

Registered aircraft · 20,683

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-06-03-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-06-03-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-06-03-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-06-03-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-06-03-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-06-03-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.

N4391LVeness Matthew B Trustee · Fairborn, OHBuilt 1966 · S/N 17254472 N4391QSpringville Flying Club · Spanish Fork, UTBuilt 1971 · S/N 17260291 N4391RCheek Kenneth W · Yadkinville, NCBuilt 1974 · S/N 17263141 N4392QRose Denver W · Eubank, KYBuilt 1971 · S/N 17260292 N4393QJkj Aviation LLC · Wilmington, NCBuilt 1971 · S/N 17260293 N4393RHorizon Dreams LLC · Homer, GABuilt 1974 · S/N 17263143 N4394LR A Marsh Flying Club LLC · Williamson, GABuilt 1966 · S/N 17254475 N4394QAircraft Resource Center Inc · Lakeville, MNBuilt 1971 · S/N 17260294 N4396LDyer John F · Spring, TXBuilt 1966 · S/N 17254479 N4396QBennett Barry J · Owasso, OKBuilt 1971 · S/N 17260296 N4397QWingsleasing LLC · Wichita, KSS/N 17260297 N4397RBuiqui Aerospace Corp · Kissimmee, FLBuilt 1974 · S/N 17263147 N4398LSutton Aircraft Salvage LLC · Palmer, AKBuilt 1966 · S/N 17254481 N4398RAlferman Thomas H · Hampton Bays, NYBuilt 1974 · S/N 17263148 N4399LEge Sidney J · Carlisle, PABuilt 1966 · S/N 17254482 N4399QHoefly Christopher · Belleview, FLS/N 17260299 N439CEMuller Jenny DBA · Cody, NEBuilt 1965 · S/N 17253171 N439ERMorey Airplane Co Inc · Middleton, WIBuilt 2001 · S/N 172S8935 N439LPTps Aviation LLC · Los Angeles, CABuilt 2003 · S/N 172S9439 N43APSchubert Edward M · Floyds Knobs, INS/N 17273802 N43FAKingsky Flight Academy LLC · Lakeland, FLBuilt 1978 · S/N 17270808 N43GFGaskins Joseph Spencer · Port Orchard, WABuilt 1980 · S/N 17274453 N4400RBophades LLC · Fort Pierce, FLBuilt 1974 · S/N 17263150 N4401LWarbelows Air Ventures · Fairbanks, AKBuilt 1966 · S/N 17254484 N4402LClements Alex F Jr · Alamogordo, NMBuilt 1966 · S/N 17254485 N4402QSummers Mark A · Alpine, WYBuilt 1973 · S/N 17261697 N4402RAvel Aircraft Inc · West Chicago, ILBuilt 1974 · S/N 17263152 N4403RGorge Aviation Services LLC · Portland, ORS/N 17263153 N4405LKopcho Thomas L · York, NEBuilt 1966 · S/N 17254490 N4405RBon Homme Flyers Inc · Tyndall, SDBuilt 1974 · S/N 17263155 N4407QSund Manufacturing Co · Newburg, NDS/N 17261698 N4409RRegistration Pending · Albany, ORRegistration pendingBuilt 1974 · S/N 17263158 N440ERChristiansen Aviation LLC · Wilmington, DEBuilt 2017 · S/N 172S12027 N440FAA-Cent Aviation Inc · Jacksonville, FLBuilt 2003 · S/N 172S9440 N440SPHoletz Consulting Inc · Minneapolis, MNBuilt 2000 · S/N 172S8357 N4410LLenhart James A · Manchester, MIBuilt 1966 · S/N 17254495 N4410QAyer Benjamin D · Newport, MEBuilt 1973 · S/N 17261699 N4410RSpane John T · Mount Airy, NCBuilt 1974 · S/N 17263159 N4413SBirmingham Flight Center LLC · Birmingham, ALS/N 17257905 N4415RNextgen Flight Academy Inc · Riverside, CABuilt 1974 · S/N 17263163 N4416LBustamante Marcos H · Nogales, AZBuilt 1966 · S/N 17254503 N4418LIroquois Soaring Assn · Rome, NYBuilt 1966 · S/N 17254505 N4418RTeton Leasing LLC · Pocatello, IDBuilt 1974 · S/N 17263166 N4419LMil2atp Inc · Pikeville, NCBuilt 1966 · S/N 17254506 N441AGAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1983 · S/N 17276091 N441CAAtp Aircraft 4 LLC · Wilmington, DEBuilt 1998 · S/N 17280441 N441DLPinion Aviation Inc · Glenbrook, NVBuilt 1976 · S/N 17267391 N441DPRhinelander Flying Service Inc · Rhinelander, WIBuilt 1975 · S/N 17265691 N441ERVeve Jesus Vila · Mayaguez, PRBuilt 2005 · S/N 172S10060 N441QFChristiansen Aviation LLC · Wilmington, DEBuilt 1997 · S/N 17280278

Back to AD 90-06-03 R1