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.

N6914JKreppel Frederick W · Wayne, PABuilt 1976 · S/N 28-7690429 N6914ULiskey John W · Kelseyville, CABuilt 1964 · S/N 246 N6914WPearson Timothy M · Waterville, OHBuilt 1965 · S/N 28-21084 N6915H2gbs LLC · Wilder, IDBuilt 1975 · S/N 17265640 N6915NBaker Stewart D · Severna Park, MDBuilt 1968 · S/N 680139 N6915QWilson Kenneth G · Peoria, AZS/N MB-278 N6915TSpier Samuel · Carson City, NVBuilt 1985 · S/N 28-8590058 N6915WOso Air LLC · Missoula, MTBuilt 1965 · S/N 28-21086 N69165Locaero Services Inc Trustee · Wilmington, DEBuilt 1985 · S/N 28-8516060 N6916HFms Air LLC · Leesville, LABuilt 1975 · S/N 17265641 N6916NGray Wesley K · Sandia, TXBuilt 1968 · S/N 680140 N6916QShawn James R · Pattison, TXS/N MB-287 N6917DOlds Forge Flyers Inc · Lansing, MIBuilt 1985 · S/N 28-8590061 N6917GMarvell Aviation LLC · Marvell, ARBuilt 1985 · S/N 28-8590062 N6917NBonak Steven · Punta Gorda, FLBuilt 1968 · S/N 680178 N6917WCloutier Michael C · Waddell, AZBuilt 1965 · S/N 28-21088 N6918DTucker Christopher W · Johnstown, COBuilt 1962 · S/N 23-2038 N6918HWright Flight Inc · Tucson, AZBuilt 1975 · S/N 17265642 N6918NBas Part Sales LLC · Greeley, COBuilt 1968 · S/N 680141 N6918WTopping Warren J · Sagaponack, NYBuilt 1965 · S/N 28-21089 N6919BPolyclinics.Net LLC · Hixson, TNS/N 22-4194 N6919HTimmester Terry W · Little River, SCBuilt 1975 · S/N 17265643 N6919JFlying Is Fun LLC · Atlanta, GABuilt 1976 · S/N 28-7615397 N6919NNicholas Dagmar H · Uniontown, OHBuilt 1968 · S/N 680179 N6919WN6919w LLC · Key West, FLBuilt 1965 · S/N 28-21090 N691DLJohnson Boyd D · Preston, IDBuilt 1992 · S/N 20192 N691DSNelson Travis K · Hamilton, MTS/N 20199 N691FLKelley Keith B · Forney, TXS/N 28-7125628 N691KWHoegg Thomas K · Mountain Home, IDS/N 20985 N691WEagle Simulator LLC · Lake Oswego, ORBuilt 1982 · S/N 17275576 N6920CKiesel James L · Hanford, CABuilt 1969 · S/N 690065 N6920GValley Boys LLC · Lakeville, MNBuilt 1985 · S/N 28-8590065 N6920NHodgman Gary W · Greenville, TXBuilt 1968 · S/N 680142 N6920PStanley Travis Navar · Dundee, OHBuilt 1960 · S/N 24-2054 N6921BKnepp Gerald L · Milroy, INBuilt 1956 · S/N 22-4197 N6921NBower Edwin M · Norco, CABuilt 1968 · S/N 680180 N6921PNormark Ronald L · Weirsdale, FLBuilt 1960 · S/N 24-2055 N6922JSystematic Management And Flight Training LLC · Kankakee, ILBuilt 1976 · S/N 28-7690431 N6922NPetrie Chris · Titusville, FLBuilt 1968 · S/N 680143 N6922WRobirds Ryan E · Wheelersburg, OHS/N 28-21095 N6923BWitzel John F Jr · Frenchglen, ORBuilt 1956 · S/N 22-4199 N6923DCline Patrick G · Granbury, TXBuilt 1957 · S/N 22-4851 N6923NTurner William H · Parkersburg, WVBuilt 1968 · S/N 680181 N6924HJeea Aviation LLC · Tyler, TXBuilt 1975 · S/N 17265647 N6924WAlpha 3 LLC · Troy, KSBuilt 1965 · S/N 28-21098 N6925NFollrath Rick C · Ludington, MIBuilt 1968 · S/N 680144 N6926DGibson Christopher R · Natchez, MSBuilt 1957 · S/N 22-4854 N6926HJust Plane Adventures Inc · Crystal Lake, ILFirst renewal noticeBuilt 1975 · S/N 17265648 N6926NTurtle Mountain Air LLC · Bottineau, NDBuilt 1968 · S/N 680183 N6926PSkyways Group LLC · Greensboro, NCS/N 24-2060

Back to AD 80-04-03 R2