Skip to content

Registered aircraft · 40,473

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:80-04-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:80-04-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:80-04-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:80-04-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:80-04-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:80-04-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.

N56406Blankenship Tyler D · Salisbury, NCBuilt 1980 · S/N 8013C N5640EHunt Jacky R · Bowling Green, KYBuilt 1978 · S/N 17271909 N5640NK Top J Cattle Co LLC · Eldorado, TXBuilt 1980 · S/N 8010C N5640UJustfly Inc · Houston, TXBuilt 1969 · S/N 28-26436 N5641AGrandy Leland P · Rock Springs, WYS/N 9005C N5641VFlight Leasing Corp · Wilmington, DES/N 28-7716188 N5641WThibodeau Tom M · Kenai, AKBuilt 1962 · S/N 28-789 N56424Saunders Equipment Inc · Cold Spring, NYBuilt 1981 · S/N 8017C N56429Norman Ronald E · Lopez Island, WABuilt 1973 · S/N 287325628 N5642TMark C Petersen · Sturgeon Bay, WIBuilt 1998 · S/N 21049C N56432Ladig Aviation LLC · Mount Washington, KYS/N 287305591 N5643QGray Eric W · Erie, COBuilt 1965 · S/N 3020 N5643UExotic Sky LLC · Kalispell, MTBuilt 1969 · S/N 28-26439 N5643ZMcduffie Rodney D · Cullman, ALBuilt 1981 · S/N 8019C N5644UDonaubauer Stefan · Charlotte, NCBuilt 1969 · S/N 28-26441 N564514gaviation LLC · Reading, PABuilt 1973 · S/N 287305595 N5645FReddoch Mark W Jr · Vidor, TXBuilt 1976 · S/N 28-7790133 N5645URegistration Pending · Huntingdon, TNRegistration pendingBuilt 1969 · S/N 28-26440 N56460Cessna 7870u LLC · Ottumwa, IABuilt 1973 · S/N 28-73-05596 N5646NTennison Gary D · Marion, TXS/N 9010C N5646UPn4 Aviation Holdings LLC · Bishop, CAS/N 28-26442 N56473Registration Pending · Fort Worth, TXRegistration pendingBuilt 1973 · S/N 287325635 N56474Sampson David M · Clancy, MTBuilt 1973 · S/N 28-7425003 N5647UVargas Orlando O · San Bernardino, CABuilt 1969 · S/N 28-26443 N5647WAuer David A · Springfield, ILBuilt 1962 · S/N 28-804 N56487Burleson Jerry H · Grapevine, TXBuilt 1973 · S/N 28-73-25639 N5648WSpinetta Lawrence J · Austin, TXBuilt 1962 · S/N 28-807 N5649GMaran Properties LLC · Lowell, ARBuilt 1979 · S/N 17273564 N5649PTalarek Kai C · Far Hills, NJBuilt 1959 · S/N 24-720 N5649QTaylor Clayton T · Stockton, KSBuilt 1965 · S/N 3023 N5649UAzille Keran · Massapequa, NYBuilt 1969 · S/N 28-26445 N5649WSmith James L Jr · Des Arc, ARBuilt 1962 · S/N 28-808 N564DFPreiss Michael C · Southaven, MSS/N 269 N564FLFlyguys Cessna 182 LLC · Royal Palm Beach, FLBuilt 1971 · S/N 28-7125406 N564PUPurdue Aviation LLC · West Lafayette, INBuilt 2002 · S/N 2842169 N5651BRoland David K · Lockhart, TXBuilt 1981 · S/N 8018C N5651QKingdom Air LLC · Diamondhead, MSBuilt 1965 · S/N 3024 N5652Leary Brian J · Fredricksburg, PABuilt 1972 · S/N 595 N56521Hawkes Tyler · Rexburg, IDBuilt 1973 · S/N 28-73-25647 N56524Registration Pending · West Palm Beach, FLRegistration pendingS/N 28-73-25650 N56525Sadi Susan Salimi · Arlington, TXS/N 28-7325651 N5652ECgumps LLC · Antioch, TNBuilt 1978 · S/N 17271912 N56536Hurlbut Gary A · Seattle, WABuilt 1973 · S/N 28-7325653 N5653PBeasley Charles R · Lumberton, NCBuilt 1959 · S/N 24-724 N5653UMcclelland Robert C · La Veta, COBuilt 1969 · S/N 28-26449 N5653WCrump William J · Williamstown, NJFirst renewal noticeBuilt 1962 · S/N 28-840 N56545Sauder Richard J · Evergreen, COBuilt 1984 · S/N 8040C N56547Schroeder Gordon D · New Braunfels, TXBuilt 1984 · S/N 8055C N5654BStol-Air LLC · Salem, ORFirst renewal noticeBuilt 1984 · S/N 8035C N5654DMiller Arlyn E · Boise, IDBuilt 1984 · S/N 8038C

Back to AD 80-04-03 R2