AD 84-10-01 R1
Registered aircraft · 20,481
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
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-10-01-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-10-01-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-10-01-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-10-01-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.
N748KPKalinin Partners LLC · Juneau, AKN7491EBenscoter Richard S · Nordman, IDN7497EDunford David R · Maryville, TNN749KPKalinin Partners LLC · Juneau, AKN749RVTime Machine LLC · Kailua Kona, HIN749SPNew York State Police · Latham, NYN74BGReliance Aviation LLC · Mendon, NYN74CGTrainor Thomas P · Fairbanks, AKN74CLWarner Thomas E · Beloit, OHN74LCLee County Sheriffs Office · Ft Myers, FLN74LJZaczkowski Paul S · Tok, AKN74MBRoland Cary T · Moscow, KSN74MGRegistered aircraftN74MKBunn Joseph D · Hugo, OKN74MMFief Ron C · Creede, CON74PSOrion Works Inc · Denali Park, AKN74RMGrimes Taylor · Odessa, TXN74SMYellow Airplane LLC · Columbus, NEN74TPN92341 LLC · Bonner, MTN74VTStorsteen Erik M · Gardena, CAN750Culver Marc D · Anchorage, AKN7505N7505 LLC · Deer Park, WAN750JPQuasar Airlines International LLC · Moncks Corner, SCN750NTEle Motorsports LLC · Dover, DEN7510KFreienmuth Karl S · Shorewood, MNN7511Travis Paul A · Defiance, OHN751CFSebec Aviation Services LLC · Abbot, MEN751DRNew Daniel A · Deming, WAN751ESHat Trick Aviation LLC · Dover, DEN751MCGrubb Kenneth W · Spring, TXN751SDenson Mark T · Brenham, TXN7520KGraber Raymond B II · Carson City, NVN7521K5b 7b Aero LLC · Sandpoint, IDN7522KDewitt David B · Santa Rosa, CAN7527KMark D Jones · Kremmling, CON7529KBarak David T · Mountain Home, IDN7529NNoam Eli M · New York, NYN752DMS&M Holdings LLC · Oak Ridge, LAN7530KMcmanigle Jeffrey M · Osakis, MNN7531NDreampad LLC · New York, NYN7532NEagle Air LLC · Morgantown, WVN7536NRomence Louis Wm · Grand Rapids, MIN7537GConway John F · Cumming, GAN7539NDavis Dale L · Boerne, TXN753DBFritz Daniel Trustee · Lodi, CAN754BMPitot Heat Inc · Huntington, NYN754MEKaetzel Anthony · Portland, ORN7551Delash John M · Williamson, GAN7551KBoone Richard Kevin · Wichita Falls, TXN7551SMiller Luke · Enumclaw, WA
Back to AD 84-10-01 R1