Skip to content

Registered aircraft · 17,027

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

N57MJFrederick Bradley W · Corvallis, ORFirst renewal noticeBuilt 1969 · S/N 18259651 N5800RPomeroy Cattle Ranch LLC · Kalispell, MTS/N 17253469 N5802RMiller Chris D · Collierville, TNBuilt 1965 · S/N 17253471 N5804GSkylands Air LLC · Port Orange, FLBuilt 1969 · S/N 15071304 N5804RGriffin David Charles · Palmyra, PABuilt 1965 · S/N 17253473 N5806FJones Flying Association · Wilmington, DEBuilt 1966 · S/N 21058806 N5807RYoung Darrin · Chillicothe, MOBuilt 1965 · S/N 17253476 N5808GMoncrieffe Ainsworth L · Aurora, COBuilt 1969 · S/N 15071308 N5809FDonnelly Robert J · Edwardsburg, MIBuilt 1966 · S/N 21058809 N5809RJ L S Agency LLC · Starkville, MSBuilt 1965 · S/N 17253478 N5811GBransky Camber · Griffin, GABuilt 1969 · S/N 15071311 N5811RGreat Plains Enterprises LLC · Wilmington, OHBuilt 1965 · S/N 17253480 N5812RPeterson Bruce G · Saint Cloud, MNBuilt 1965 · S/N 17253481 N5814GEricson Eric · Saint Charles, ILBuilt 1969 · S/N 15071314 N5814RBrown Jacob M · Boswell, PABuilt 1965 · S/N 17253483 N5815FHubbard Scott N · New Brighton, MNBuilt 1966 · S/N 21058815 N5815RLambson Roger · Saint Ignatius, MTBuilt 1965 · S/N 17253484 N5816GGwyn Devin R · Dallas, ORBuilt 1969 · S/N 15071316 N5816RLittle Bird Airways LLC · Hamburg, NYBuilt 1965 · S/N 17253485 N5817GWilliams James B · Bonifay, FLBuilt 1969 · S/N 15071317 N5818GCirri Joseph F · Deming, NMBuilt 1969 · S/N 15071318 N5818RVanthof Douglas D · Sioux Falls, SDBuilt 1965 · S/N 17253487 N5819GBuchanan Jason A · Nampa, IDBuilt 1969 · S/N 15071319 N581CGLoveless Jacob L · Carlinville, ILBuilt 1966 · S/N 17255581 N5820RBlack Jan P · Yucaipa, CABuilt 1963 · S/N 18254795 N5821FFlite Five Inc · Kiowa, KSBuilt 1966 · S/N 21058821 N5821GMatthews Cheyenne B · Marion, IAS/N 15071321 N5822FGrein David A · Mokena, ILS/N 21058822 N5822GRada Michael F · Eagan, MNS/N 15071322 N5824GNairways LLC · Dix Hills, NYS/N 15071324 N5825GAuxano Aviation LLC · Newark, DES/N 15071325 N5826GKingdom Art LLC · Cologne, MNS/N 15071326 N5827FBok Hans · North Dartmouth, MABuilt 1966 · S/N 21058827 N5827GHutchinson Linda M · Grass Lake, MIBuilt 1969 · S/N 15071327 N5828FKissell Ryan · Mount Vernon, OHBuilt 1966 · S/N 21058828 N5828GSmith Joshua B · Kenai, AKS/N 15071328 N5828RBismark Public Schools · Bismarck, NDBuilt 1971 · S/N 15072234 N5829FMoa Klinton J · Bellingham, WABuilt 1966 · S/N 21058829 N5830FSuchy Karel · Kenosha, WIBuilt 1966 · S/N 21058830 N5830GDunn Michael J · Ozark, ARBuilt 1969 · S/N 15071330 N5832GFitzgibbon Patrick D · Waterloo, WIS/N 15071332 N5833FVermillion Fc-1 LLC · Crystal City, TXBuilt 1966 · S/N 21058833 N5842FHci Properties LLC · Frankston, TXBuilt 1967 · S/N 21058842 N5843FU3 Aviation LLC · Little Rock, ARS/N 21058843 N5844GLummus David R · West Point, MSBuilt 1969 · S/N 15071344 N5845GBerg William J · Aberdeen, SDS/N 15071345 N5848GDerby City Aviation LLC · Vero Beach, FLBuilt 1969 · S/N 15071348 N584SFDsr Cherokee 180 LLC · Dallas, TXBuilt 1968 · S/N 17256834 N5850F5850f LLC · Monroe Township, NJBuilt 1967 · S/N 21058850 N5851RSmoky Bear Air LLC · Rockwood, TNBuilt 1965 · S/N 17253520

Back to AD 72-03-03 R3