AD 84-10-01 R1
Registered aircraft · 20,485
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.
N1804FWaage Todd · Greenbush, MNN18053Kraft Tyrone H · Timber Lake, SDN18055Plane Fun Inc Tr Trustee · Snellville, GAN1806RFly By Night Aviation Inc · Pleasantville, NYN1806XBrowning Lonnie O IV · Allendale, SCN18075Northwestaildraggers LLC · Washougal, WAN1807RVeldman Richard D · Laporte, INN1808XM&M Land Company LLC · Marietta, OHN1808ZFlanagan Enterprises (Nevada) Inc · Zephyr Cove, NVNon-citizen corporation, flight hours not reportedN1809XMilburn Thomas D Trustee · Lompoc, CAN1809ZCleared For Departure LLC · Kennewick, WAN180AHigginbottom Nathan · Cave City, ARN180AAButler Tracey D · Buckley, WAN180ABFoster Bradley J · Wichita, KSN180AFRegistered aircraftN180AGAg Leasing LLC · Wilmington, DEN180AHSwiss Arctic Flyers Inc · Lewes, DEN180AKBecker Kurt G · Dexter, NMN180ANJones Marvin B · Farmerville, LAN180APAir Plains Services Corp · Wellington, KSN180AQTracy Michael R · Santee, CAN180AXNoyes Abigail · North Pole, AKN180AYPerkins Paul Fortaine · Anchorage, AKN180AZMohr Elizabeth G · Brandon, MSN180BADavis Robert D · Camas, WAN180BBSouthern Aircraft Consultancy Inc Trustee · Casper, WYN180BDSanderson Bryan D · Emmett, IDN180BFComunale Anthony S · Roxbury, CTN180BGCmw Aircraft LLC · Hailey, IDN180BHMorris Christopher H · Valparaiso, INN180BKKrissman Ryan · Gallup, NMN180BRDainas Barry · Port Orange, FLN180BSSerie Dennis P · Chugiak, AKN180BTAerobug LLC · League City, TXN180CBrown Hector M · Glenwood Springs, CON180CBSmith Dennis A Trustee · Salem, ORN180CDHicks P David · Heber City, UTN180CETailwinds Ranch LLC · Orlando, FLN180CJWipaire Inc · South Saint Paul, MNN180CRSnow Robert J · La Mesa, CAN180CTPerformance Paradise LLC · Eagle Harbor, MIN180CYYoung Ideas LLC · Post Falls, IDN180DProuty Edgar C Jr · Sebec, MEN180DAAalgaard Raymond F · Hollister, CAN180DCWilson Lewis G Jr · Rock Hill, SCN180DFSale Reported · Anchorage, AKSale reportedN180DGHodnett Stephen T · Canadian, TXN180DHMarden Aero Services LLC · Erwinna, PAN180DJHuang Sophie M · Newcastle, WAN180DKGriffin Vaughn · Spirit Lake, ID
Back to AD 84-10-01 R1