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.

N29FLTorres Chris · Princeton, CABuilt 1968 · S/N 18258813 N29JFJkg LLC · Murfreesboro, TNBuilt 1968 · S/N 18259450 N29LKGibbons David · Holmen, WIS/N 177RG0736 N29NDDamstetter Katherine M · Hudson, FLS/N 15066888 N2AWSpacecrafters Inc · Silver Springs, FLBuilt 1971 · S/N 17701692 N2BFMs Aero Inc · Lakeville, OHBuilt 1968 · S/N 15068499 N2BPMiami Clipper Aviation LLC · Cutler Bay, FLBuilt 1972 · S/N 17701783 N2EBCampbell Bernard D · Morehouse, MOBuilt 1971 · S/N 18260609 N2GHAbel Robert G · Williamstown, MABuilt 1963 · S/N 2050369 N2JHReign Air Charter Corp · New Port Richey, FLBuilt 1964 · S/N 17252443 N2KDElliott Frank F · Mojave, CAFirst renewal noticeBuilt 1969 · S/N T210-0436 N2KFLivingston H Clark · Akron, ALBuilt 1968 · S/N 17700997 N2KGLowe Samuel S III · Mary Esther, FLBuilt 1974 · S/N 17702073 N2TAMontgomery Keith L · Florence, ALBuilt 1972 · S/N 15073811 N3000QFlying H Enterprises · Santa Fe, NMBuilt 1967 · S/N 18258000 N3000YChesebro Ben D · Tucson, AZBuilt 1962 · S/N 18254000 N30013Patton Mark E · Dryden, NYBuilt 1968 · S/N 17701023 N30014Tri-State Aviators LLC · Ironton, OHBuilt 1968 · S/N 17701024 N30017Landon Kasiri · Lancaster, CABuilt 1968 · S/N 17701025 N3002QJaeger Christopher E · Normandy Park, WABuilt 1967 · S/N 18258002 N3002YGiefer Brett T · Nicollet, MNBuilt 1962 · S/N 18254002 N30033Mission Aviation Training Academy · Arlington, WABuilt 1968 · S/N 17701036 N3003FHassinger Farms LLC · Cove, ORBuilt 1966 · S/N 18257103 N3003XAero Flyers LLC · Stephenson, VABuilt 1966 · S/N 15064403 N30040Schaller Neil J · New Athens, ILBuilt 1968 · S/N 17701043 N30043Singer Mark D · Stafford, VABuilt 1968 · S/N 17701045 N30044Air Data Solutions LLC · Natchitoches, LABuilt 1968 · S/N 17701046 N3004FN3004f LLC · Cranberry Township, PABuilt 1966 · S/N 18257104 N3005FE & E Jones Farms LLC · Munford, ALBuilt 1966 · S/N 18257105 N3005SSpennato Peter Jr · Rolling Hills, CABuilt 1967 · S/N 15066905 N3005XOso Air LLC · Missoula, MTBuilt 1966 · S/N 15064405 N30064Avarix Inc · Cool, CAS/N 17701053 N3006QHarrington Michael L · Twin Falls, IDS/N 18258006 N3006SGrice Warren A · Marshall, ARBuilt 1967 · S/N 15066906 N3006XRegistration Pending · Scottsdale, AZRegistration pendingBuilt 1966 · S/N 15064406 N3006YWissner Martin L · Carpenter, WYBuilt 1963 · S/N 18255082 N3007FTroelstra Frederick D · Queensbury, NYBuilt 1966 · S/N 18257107 N3007XKelley Keith B · Forney, TXBuilt 1966 · S/N 15064407 N3008XAdams Harold L · Beaver, OHBuilt 1966 · S/N 15064408 N3008YWidmier Kolby J · Price, UTBuilt 1962 · S/N 18254008 N30096Sirek David G · Fritch, TXBuilt 1968 · S/N 17701057 N30098Humbert Randy M · Tumtum, WAS/N 17701059 N3009SRegistration Pending · Arlington, TXRegistration pendingBuilt 1967 · S/N 15066909 N3009XWarren Jeremy I · Horse Cave, KYBuilt 1966 · S/N 15064409 N300BWWatson Brent J · Bountiful, UTBuilt 1965 · S/N 18256725 N300DFDowner Justin W · Berthoud, COBuilt 1966 · S/N 18257109 N300EMMark Thomas Productions LLC · Ketchum, IDBuilt 1966 · S/N 18257529 N300KTKarnowski Ventures LLC · Manhattan, KSBuilt 1963 · S/N 18255095 N300PAmerican Aviator LLC · Arlington, TXBuilt 1976 · S/N 177RG0989 N300PSRight Coast Ventures LLC · Royse City, TXBuilt 1968 · S/N 17257501

Back to AD 72-03-03 R3