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.
N5086NSnoopy Aviation Ltd · San Antonio, TXN5087BSchwebach Victoria L · Coronado, CAN5087DPenz Johnathan D · Russian Mission, AKN5088DBaughman Jeffrey S · Keller, TXN5088USinnott Simonis Lyle · Girdwood, AKN5089C5089c LLC · Fairhope, ALN5089DMorales Josh S · Anchorage, AKN5089EEgger Gary L · Edmond, OKN5089V89v LLC · Bethlehem, PAN508EJones Ronald C · Walters, OKN508TCFisher Travis L · Odessa, TXN50901United Indian Missions Inc DBA · Tucson, AZN5090UVolatile Aero Ventures LLC · Boulder City, NVN5091DKuhn Chad · Boulder, WYN5091VWilliams Timothy J · Fernandina Beach, FLN50937Tls Aviation LLC · Eldridge, IAN50939Heart X Aviation LLC · Salmon, IDN50958Stangel Richard C · Enterprise, ORN5095DTevik Michael A · Provo, UTN5095ESchroeder Michael L · Ayr, NDN5097NDevericks Richard · Ventura, CAN5098DShepard Mark S · Malin, ORN5098NReed Kenneth C · Hollywood, MDN5099NRabinowitz Jeffrey Evan · Akron, OHN509ARRegistered aircraftN509BWAnderson Richard D Jr · Remus, MIN50CGDixon Jack · Casa Grande, AZN50CHBaker Harold · Byrdstown, TNN50CPAtkins Daniel E · Marlette, MIN50CTAyers Jeffrey D · Canandaigua, NYN50CXChristmas Candy · Angel Fire, NMN50HWMills Charles K · Hernando, FLN50JCJg Air LLC · Wilmington, DEN50LZRegistered aircraftN50MBCivil Air Patrol Inc · Maxwell Afb, ALN50PZHill Robert P · Naknek, AKN50RAWilson Kirk · Glennallen, AKN50RFFecteau Robert · Taylorsville, NCN5100XSmith Ronald N · College Station, TXN5101DGavin Ronald A · East Helena, MTN5101NMerrill Charles Jay · Manhattan, KSN5101UMichigan Department Of Natural Resources · Roscommon, MIN5101YSchrock Marvin J · Sterling, AKN5103EShannon Patrick · New Waverly, TXN5105DPaulsden LLC · Caldwell, IDN5105ESayers James B · Edison, OHN5105YMcduff Douglas M · Cook, MNN5106CQuest Aviation Inc · Lake City, FLN5106DOut Of The Blue Skydiving LLC · Parker, CON5107CDalrymple Michael J · San Luis Obispo, CA
Back to AD 84-10-01 R1