Skip to content

Registered aircraft · 68,375

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.

N28020Cae Aviation Academy Phoenix LLC · Mesa, AZBuilt 2020 · S/N 2881349 N28027Cae Aviation Academy Phoenix LLC · Mesa, AZBuilt 2020 · S/N 2881350 N28029Cae Aviation Academy Phoenix LLC · Mesa, AZBuilt 2020 · S/N 2881351 N2802MSkyone Aero Services LLC · Castro Valley, CABuilt 1977 · S/N 28-7816312 N2802TRandolph Clint · Bullhead City, AZBuilt 1972 · S/N 28R-7235134 N2802ZPeavler Christopher · Modoc, SCS/N 22-6795 N28030Cae Aviation Academy Phoenix LLC · Mesa, AZBuilt 2020 · S/N 2881352 N28034Cae Aviation Academy Phoenix LLC · Mesa, AZBuilt 2020 · S/N 2881357 N2803PLewis Stephen R · Chillicothe, ILBuilt 1955 · S/N 22-3095 N2803TBarron David L · Sun City, AZBuilt 1972 · S/N 28-7225241 N2803XStamper Douglas H · Norfolk, VABuilt 1967 · S/N 17700203 N28042Sas Aviation LLC · Carroll, OHBuilt 1940 · S/N 4542 N28043Cae Aviation Academy Phoenix LLC · Mesa, AZBuilt 2020 · S/N 2881358 N28045Cae Aviation Academy Phoenix LLC · Mesa, AZBuilt 2020 · S/N 2881359 N2804MEhrenborg Robert J · Fisherville, KYBuilt 1977 · S/N 28-7890269 N2804ZWatson Jennifer R · San Jose, CABuilt 1978 · S/N 371-78 N28051Cae Aviation Academy Phoenix LLC · Mesa, AZBuilt 2020 · S/N 2881360 N28053Cae Aviation Academy Phoenix LLC · Mesa, AZBuilt 2020 · S/N 2881379 N2805QA L Hollandsworth LLC · Columbia, MOBuilt 1971 · S/N 17259805 N28065Cae Aviation Academy Phoenix LLC · Mesa, AZBuilt 2020 · S/N 2881380 N28069Cae Aviation Academy Phoenix LLC · Mesa, AZBuilt 2020 · S/N 2881381 N2806BHeliflight Leasing LLC · Bulverde, TXBuilt 1956 · S/N 1490 N2806EBexar Aviation LLC · San Antonio, TXBuilt 1978 · S/N 17271328 N2806MCondor Aero Club Inc · Zelienople, PABuilt 1977 · S/N 28-7890270 N2806QLawson Lance J · Sikeston, MOBuilt 1971 · S/N 17259806 N2806TN2806t Leasing Company LLC · Mason, MIBuilt 1972 · S/N 28-7205223 N2806WOllmann Paul W · Poplar Grove, ILBuilt 1995 · S/N 1 N2807BSuess Robert D · San Jose, CABuilt 1956 · S/N 1495 N2807EMission One LLC · Excelsior, MNBuilt 1978 · S/N 17271329 N2807QReynolds David F · Port Orange, FLBuilt 1971 · S/N 17259807 N2807RHayzan Aviation LLC · Wilmington, DEBuilt 1969 · S/N 28R-35294 N2807TSale Reported · Broxton, GASale reported, canceledBuilt 1972 · S/N 28-7205224 N28086Cae Aviation Academy Phoenix LLC · Mesa, AZBuilt 2020 · S/N 2881392 N28088Cae Aviation Academy Phoenix LLC · Mesa, AZBuilt 2020 · S/N 2881393 N28089Clive Consulting LLC · Dover, DEBuilt 1940 · S/N 4570 N2808MJensen John C · Mccleary, WAS/N 12-1261 N2808PValiair Limited Co Trustee · Casper, WYBuilt 1955 · S/N 22-3101 N2808UCoastal Flight Inc · Half Moon Bay, CAS/N 1056 N2809Piper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 28010051 N28090Cae Aviation Academy Phoenix LLC · Mesa, AZBuilt 2020 · S/N 2881394 N28095Cae Oxford Aviation Academy Phoenix Inc · Mesa, AZBuilt 2020 · S/N 2881395 N28096Cae Aviation Academy Phoenix LLC · Mesa, AZBuilt 2020 · S/N 2881405 N28098Cae Aviation Academy Phoenix LLC · Mesa, AZBuilt 2020 · S/N 2881406 N2809CNixon Ross M · Hillsboro, ORBuilt 1954 · S/N 26352 N2809MCarlos Sean N · Togiak, AKBuilt 1946 · S/N 12-1265 N2809PDavis Gerald R · Hernando Beach, FLS/N 22-3102 N2809XGuckian Jim J · Riverdale, GABuilt 1967 · S/N 17700209 N280AL2e2 Corporation · Menlo Park, CABuilt 1980 · S/N 1210 N280AGWings Over Texas Holdings LLC · Denton, TXBuilt 2020 · S/N 4496511 N280AMSabol John · Smithville, TXBuilt 2004 · S/N 20-1041

Back to AD 90-04-06 R1