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.
N33WAThompson Casey · Edmond, OKN33WHBarkley Daniel L · Denton, TXN33WJKite Air LLC · Staten Island, NYN33WKSager Earl Dwayne · Perryton, TXN33WNClover Crest II Inc · Key Largo, FLN33WVInarayan Inc · Winter Park, FLN33XXPtacek Stephen R · Estes Park, CON33YBBriggs Kent · Manhattan, KSN33YMDiedrich William Walter · Firebaugh, CAN33YYMoore Keith V · Germantown, TNN33YZJenkins Blake T · Lakeland, FLN33ZCMarker Michael M Jr · Los Lunas, NMN33ZDBentley Jeffrey W · Kenmore, WAN33ZMUrban Timothy J · Laytonsville, MDN33ZXLisi Richard A · Palm City, FLN3400Mahar James · Pompano Beach, FLN34005Hinckley David D · Belton, TXFirst renewal noticeN3400FSpencer Aviation Services LLC · Sanger, TXN3400WTop Flight Aircraft Holdings LLC · Dover, DEN3400ZHojnacki Frank · Hobart, INN34011Cross Charles W Jr · Willoughby, OHN34012Cap Flyers Aero Club LLC · Ocala, FLN34015Leftwich Brian · Savannah, GAN34019Kortum Ronald L · Williamstown, NJN3401SSonntag Robert Dennis · Volant, PAN3401WAerial Crop Protection Inc · Belle Glade, FLN3402Nitzsche Ren · Winter Garden, FLN34029Rigdon William K · Hazel Green, WIN3402FTran Dzung V · Las Vegas, NVN3402RBurton Darrell · Somerset, KYN3402WCw Baker Investments LLC · Baton Rouge, LAN34038B&B Cardinal LLC · Alexandria, VAN3403PCarper Ryan W · Marietta, OHN3403ULintvedt Brian · Presho, SDN3403WSchendel Daryl R · Barstow, CAN3403XWenkman Michael J · Madison, WIN3403ZCharpie Mark E · Ottawa Lake, MIN34041Lange Charles A · Portageville, MON34043Wrg Flyers LLC · Denver, CON34045Ackerman Mark R · Box Elder, SDN34049Osetek James · Harbor Springs, MIN3404FJones Jimmy N · Bremond, TXN3404RHuffstetler Don · Mount Vernon, TXN3404THaik Kevin Jerome · Ozark, MON3404XAero Nautical Electronics Inc · Starke, FLN3404YCedar Sky Aviation LLC · Wrangell, AKN3404ZSale Reported · Poulsbo, WASale reportedN34052Bauerle William L · Imperial, NEN3405FGo Up High LLC · Grafton, WIN3405QHardin David A · Tukwila, WA
Back to AD 2007-04-19 R1