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.
N378BJenkins Kenneth S · Milton Freewater, ORN378BLBlue Line Aviation LLC · Smithfield, NCN378BPBlue Sky Education Inc · Louisville, KYN378CACivil Air Patrol · Maxwell Afb, ALN378DSMaya Air Services LLC · Lee, NHN378FJSouthern Aircraft Consultancy Inc Trustee · Casper, WYN378GPE Graham Investments LLC · Sanford, FLN378JRay Preston C · Chula Vista, CAN378JAYale Companies LLC DBA · Indianapolis, INN378JGByrkit Dale D · Clay Center, NEN378JPN8zw LLC · East Hampton, NYN378MManly Michael · Lake Panasoffkee, FLN378MARussell Robert Q · Genoa City, WIN378RSKempton Larry J III · Grand Junction, CON378SStarr William E · Eagle River, AKN378SPCivil Air Patrol Inc · Maxwell Afb, ALN378TCampisi James R · Senoia, GAN378VSSuciv Andronic · Orangevale, CAN378WMHelo Holdings LLC · South Fork, CON378ZHamilton Christopher · Dallas, TXN3790WScudder Adam J · Orlando, FLN3791DRoberts James O · Billings, MTN3791TMakowski Edward J · Barberton, OHN3791UHarway Inc · Rockingham, NCN3791WCherokee Trail Aviation LLC · Tontitown, ARN3791YSatanta Flying Service Inc · Satanta, KSN3792GNogle Charles H · Champaign, ILN3792TBrowning Marvin Robert · Berthoud, CON3792WFrazer Thomas · Warren, ARN3793MVan Wagner Aerial Media LLC · Hollywood, FLN3793QMartin Tully T · Idalou, TXN3793UFly Direct Inc · La Porte, INN3793WBas Part Sales LLC · Greeley, CON3793YBest Aircraft Deals LLC · Salt Lake City, UTN3793ZHentges Jerry J · Morris, MNN3794DDelahousie David L · Apple Valley, CAFirst renewal noticeN3794K10 Skies LLC · Rockport, TXN3794NLc Aviation LLC · Hartland, WIN3794PBellamy Flying LLC · Elwood, NEN3795QGreen Aviation Inc · Manchester, MEN3795TCrossen Executive LLC · Missouri City, TXN3795WWendt Aaron · Temecula, CAN3795ZDieffenderfer John C · Palmer, AKN37960Buth Eugene · Wellborn, TXN3796692nd West Aviation Inc · Lonoke, ARN3796CPro Aire Cargo & Consulting Inc · Oshkosh, WIN3796DHowerton Pamela S · Bartlesville, OKN3796GSantos Aviation LLC · Chico, CAN3796TWhitmore Allen R · Crestview, FLN3797DGeorge Daniel K · West Union, SC
Back to AD 2007-04-19 R1