Skip to content

Registered aircraft · 5,075

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:84-19-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:84-19-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:84-19-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:84-19-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:84-19-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:84-19-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.

N89GBHerrington Kevin · Honey Grove, TXS/N 24-4779 N89PABrewer Robert Kevin · North Bend, ORBuilt 2000 · S/N T20608157 N8APMatthews Aviation LLC · Hardinsburg, KYBuilt 1973 · S/N 27-7305072 N8AQMiller Donald W · Harrisonburg, VABuilt 1975 · S/N 61P-0222-027 N8CTOpitz Airways Inc · Belleair, FLBuilt 1973 · S/N 27-7305094 N8LXAerospace Trust Management LLC Trustee · Wilmington, DEBuilt 1969 · S/N 3065 N8NYTap Family Corp · Wilmington, DEBuilt 2002 · S/N 3257270 N8PT10wg LLC · Newman Lake, WABuilt 1973 · S/N 32-7440024 N8RGGrimes Raymond L Trustee · Los Alamitos, CABuilt 1979 · S/N 32R-8029012 N8RUN8ru LLC · Sedona, AZBuilt 1976 · S/N 31-7612109 N8ZBEastern Nevada Aviation LLC · Gardnerville, NVBuilt 1997 · S/N 3257011 N9004PFlying R Aviation LLC · Cherokee, IAS/N 24-4465 N9006FSeasky27 Productions LLC · Forked River, NJBuilt 1976 · S/N 32R-7780121 N9006PSage Building Construction Inc · Roosevelt, UTBuilt 1966 · S/N 24-4467 N9007PKoval Andor A · Yerington, NVBuilt 1966 · S/N 24-4468 N9008PStarnes William H · Eureka Springs, ARBuilt 1966 · S/N 24-4469 N9009YConchas Abel · Boiling Springs, SCBuilt 1967 · S/N 31-14 N900AKNorthern Aviation LLC · Palmer, AKBuilt 1976 · S/N 61P-0365-115 N900CGMarc Inc · Bolton, MSBuilt 1975 · S/N 31-7612002 N900GPPerkins E G Jr · Greenwood, MSBuilt 1966 · S/N 24-4464 N900JLRed Baron LLC · Pooler, GAS/N 32R-7680181 N900KKSpears Aerial Crop Care LLC · Mamou, LABuilt 2005 · S/N T18208401 N900NFPetros LLC · Bend, ORS/N T18208494 N900TSMidwest Flying Service Inc · Sheldon, IABuilt 1974 · S/N 27-7405429 N9013PRegistered aircraftBuilt 1966 · S/N 24-4474 N901BLMaritime Helicopters Inc · Homer, AKBuilt 1971 · S/N 32-7140030 N901BWKraft Tyrone H · Timber Lake, SDBuilt 1976 · S/N 32R-7680451 N901MAWings Of Ber LLC · Fort Payne, ALBuilt 2000 · S/N 46-36301 N9020PLindsay Terry M · West Hills, CABuilt 1966 · S/N 24-4482 N9021PFontenot Monty Jason · Aiken, SCBuilt 1966 · S/N 24-4483 N9022PAcc Air Charter Company · Wilmington, DEBuilt 1966 · S/N 24-4484 N9023PHand Joseph Michael · Sheboygan Falls, WIBuilt 1966 · S/N 24-4485 N9024PBlue Skies Above LLC · Bogart, GABuilt 1966 · S/N 24-4486 N9025PIdeation Machine LLC · Las Vegas, NVS/N 24-4487 N9028PBray Nick R Trustee · China Spring, TXBuilt 1966 · S/N 24-4490 N9029PEzzell Stephen Mark · Statesville, NCS/N 24-4491 N90339Bas Part Sales LLC · Greeley, COBuilt 1975 · S/N 61P-0196-015 N9033PMiddletown LLC · Chandler, AZBuilt 1966 · S/N 24-4495 N90349Williams David Anthony · Port Saint Lucie, FLBuilt 1975 · S/N 60-0202-090 N9034PNational Test Pilot School · Mojave, CABuilt 1966 · S/N 24-4496 N9037PJack Ryan Aviation · Woodcliff Lake, NJS/N 24-4500 N9042PWt Del Pl LLC · Newark, DEBuilt 1966 · S/N 24-4505 N904JDTd Ventures Inc · Las Vegas, NVBuilt 2000 · S/N T20608195 N904SCMedical Disposables Corp · Orlando, FLBuilt 1981 · S/N 31-8152194 N90509Mccollum Timothy L · Toccoa, GABuilt 1976 · S/N 60-0297-111 N9050PFrisbee Robert P · Mcminnville, ORBuilt 1966 · S/N 24-4515 N9052PVentura Alejandro · Lakeside, CABuilt 1966 · S/N 24-4518 N9053POhlstein Michael R · Glen Head, NYBuilt 1966 · S/N 24-4519 N9055PB Dot Air LLC · Jackson, WYBuilt 1966 · S/N 24-4521 N9056PMarion Brian R · Denver City, TXBuilt 1966 · S/N 24-4522

Back to AD 84-19-03 R1