Skip to content

Registered aircraft · 20,687

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.

N80507High Flight Academy LLC · Allison Park, PABuilt 1976 · S/N 17266626 N8050EPerun Av LLC · Cliffside Park, NJBuilt 1978 · S/N 17272122 N8050LRobinette William B · Youngstown, OHBuilt 1967 · S/N 17256250 N80511American Patrols Inc · Midland, TXBuilt 1976 · S/N 17266629 N80517Powers Tia Nichole · Griffin, GABuilt 1976 · S/N 17266633 N80519Donald Ben B II · Carthage, TXBuilt 1976 · S/N 17266634 N8051XBas Part Sales LLC · Greeley, COBuilt 1961 · S/N 17248551 N80522Mikhael Hanna M · Livonia, MIBuilt 1976 · S/N 17266636 N80525Dunkin Aviation LLC · Hensley, ARBuilt 1976 · S/N 17266637 N80526Stoddard County Flyers Inc · Dexter, MOBuilt 1976 · S/N 17266638 N8052XLafayette Aero Club Inc · West Lafayette, INBuilt 1961 · S/N 17248552 N80531R N R Aviation LLC · Malaga, WABuilt 1976 · S/N 17266639 N80533Euroaviation Inc Trustee · KematenS/N 17266640 N80534Millionair Inc · Ferndale, WAS/N 17266641 N80535Aerial Specailties Inc · Decatur, TXS/N 17266642 N80536Fremont Flight Academy LLC · Fremont, OHBuilt 1976 · S/N 17266643 N80537Clark Robert E · Meridian, MSBuilt 1976 · S/N 17266644 N8053LSasser Jeremiah · Ceres, CABuilt 1967 · S/N 17256253 N80543Redwire LLC · Collierville, TNBuilt 1976 · S/N 17266647 N80548Southwest Flyers Inc · Spring Branch, TXBuilt 1976 · S/N 17266648 N8054LAdams Clint D · San Antonio, TXBuilt 1967 · S/N 17256254 N80554Green Lawrence M · Las Vegas, NVBuilt 1976 · S/N 17266651 N8055BBraginetz Nathan Edward · Crozet, VABuilt 1957 · S/N 29855 N8055LRowden Paul G · Wichita, KSBuilt 1967 · S/N 17256255 N8056LJenkins Mark · Santa Clarita, CABuilt 1967 · S/N 17256256 N8056XKerekes John J · Tucson, AZBuilt 1961 · S/N 17248556 N80575Wallace Hunter Garrett · Park Hill, OKBuilt 1976 · S/N 17266656 N80578First Eclipse Ltd · Richmond, VABuilt 1976 · S/N 17266657 N8057LSale Reported · Kirksville, MOSale reportedBuilt 1967 · S/N 17256257 N80585Ck Leasing Services LLC · Wilmington, DEBuilt 1976 · S/N 17266660 N8058BBreisch Frederick A Jr · Findlay, OHBuilt 1957 · S/N 29858 N80590Air Ward Inc · Novato, CABuilt 1976 · S/N 17266663 N80597Panker Patricia A · Lake Havasu City, AZS/N 17266666 N805AABradley Air Investments LLC · New Ulm, TXBuilt 2007 · S/N 172S10498 N805CPCivil Air Patrol · Maxwell Afb, ALBuilt 2021 · S/N 172S12625 N805FWMedary Aviation LLC · Brookings, SDBuilt 2000 · S/N 172S8348 N805KSKansas State University · Salina, KSBuilt 2025 · S/N 172S13392 N805SPCertified Aviation LLC · Morristown, NJBuilt 1999 · S/N 172S8109 N80602Crass Harold L · Albuquerque, NMBuilt 1976 · S/N 17266668 N8060LOneonone Flight Training LLC · Hagerstown, MDS/N 17256260 N80612Wodishek Mark A · Honolulu, HIBuilt 1976 · S/N 17266670 N80616Aero Equities LLC · Ventura, CABuilt 1976 · S/N 17266671 N80619Level Flight Aviation LLC · Prior Lake, MNS/N 17266673 N8061BUrioste Zachary Ty Fred · Fort Collins, COBuilt 1957 · S/N 29861 N8061LColeman Terrence C · Maryville, TNBuilt 1967 · S/N 17256261 N8061XSteck Phillip G · Smartsville, CAS/N 17248561 N80620Dkr Flyers LLC · Vandalia, MOBuilt 1976 · S/N 17266674 N80627Darke County Aircraft Rental Inc · New Madison, OHBuilt 1976 · S/N 17266676 N80628Goyne Gregory Ashley · Wrangell, AKS/N 17269062 N8062BPalmer Felix E Jr · Murphy, NCBuilt 1957 · S/N 29862

Back to AD 90-06-03 R1