AD 2007-04-19 R1
Registered aircraft · 108,434
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:2007-04-19-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:2007-04-19-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:2007-04-19-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:2007-04-19-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.
N540ADHorst Kendall N · Smoketown, PAN540ARAmerican Rentals 6 LLC · Dousman, WIN540AWMyers Thomas R · Palo Alto, CAN540BBMey Gary P · New Bern, NCN540BCBeranek James · Cottage Grove, ORN540BELemons Brooks D · Visalia, CAN540BFMiller Justin S · Cedar Rapids, IAN540BHExtreme Attitude Recovery & Aerobatics LLC · Cincinnati, OHN540BJGreene Charles A · Pilot Point, TXN540BKPaggen Troy D · Parker, CON540BMInternational Air Services Inc Trustee · Carson City, NVN540BRRegistered aircraftN540BSSeay Edward A · Signal Mountain, TNN540BTChristensen Hans P · Enterprise, UTN540CEEverel Airborne LLC · Sandia Park, NMN540CFCertified Aviation LLC · Morristown, NJN540CWCentral Washington University · Ellensburg, WAN540CZOrr David A C · Lake Forest, CAN540DASmith Dustin · Layton, UTN540DGHargreaves William A · Lovettsville, VAN540DML-Bird LLC · Hood River, ORN540DRToribio LLC · San Antonio, TXN540DTGibbs Robbie L · Cave Creek, AZN540DYYeager Joseph H · Zionsville, INN540EDMorgan Gary R · Moses Lake, WAN540ESMike Scott Aviation LLC · New Orleans, LAN540ETBowen Kennith M II Trustee · Winters, CAN540EZEsselstyn Chris D · Waukesha, WIN540FTail Wheel Solutions LLC · Wilmington, DEN540FCRaschio Ernesto · Doral, FLN540FLGregory James A · East Burke, VTN540GRichards Robert F · Downers Grove, ILN540GLEdison Scott Industrial LLC · Milan, MIN540GNNorman Gregory A · Royal Oak, MIN540HW Yerxa LLC · Colusa, CAN540HASouthern Aircraft Consultancy Inc Trustee · Casper, WYN540HRRocket Two LLC · Brighton, CON540HTParadis Krysta J · Washington, DCN540JNext Aviation LLC - Aether Machinis · Evanston, ILN540JCFedorko Daniel J · Saylorsburg, PAN540JFCheely Matthew G · Hillsdale, MIN540JKMilanovo Property Holdings Co LLC · Dover, DEN540JPSchwartz Stephen R · Goldthwaite, TXN540JRHrabe John · Orland Park, ILN540KLJohannes Dale R · Whitefish, MTN540KMKreuter Engineering · New Paris, INN540KSKent State University · Stow, OHN540KYAnikin Aviation Inc · Amsterdam, NYFirst renewal noticeN540LLAnderson James D · Russell, KSN540LYPlane Fun Inc Tr Trustee · Snellville, GA
Back to AD 2007-04-19 R1