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.
N381CPCivil Air Patrol · Maxwell Afb, ALN381CRSiemsen Randall R · Clovis, CAN381DProfessional Training Aircraft LLC · Wilmington, DEN381DCJackson Richard D · Ninety Six, SCN381DFSouth & Silver Aviation LLC · Pikesville, MDN381DMStuart John R · Taylorsville, KYN381DSFlightpath Investments LLC · Ottumwa, IAN381FCBrown Shane · Ozark, MON381GAtp Taa LLC · Wilmington, DEN381HBargainnier David R · Reedsville, PAN381JUS Aviation Group LLC · Denton, TXN381LMorgan Fred M · Onancock, VAN381LJBlue Rudder Aviatoin LLC · Excelsior, MNN381MAKnight Wings LLC · Matthews, NCN381MBStrobridge Mark D · Bunnell, FLN381MGMissionary Air Group Inc · Burlington, NCN381NDUnd Aerospace Foundation · Grand Forks, NDN381SBettys Beech LLC · Conway, ARN381TCShumate Frank T · Rockport, TXN381WGGoodman Bob · Opelika, ALN381XMead Lane · Minocqua, WIN38204Louw-Defazio Joan Trustee · Temecula, CAN38206Bean John R · San Antonio, TXN38208Jb Airways LLC · Linden, PAN3820LFly A Twin LLC · Kirkland, WAN3820MIsrael Howard A · Santa Monica, CAN3820RAnagnos Nick C · East Moline, ILN3820T3820t Aviation LLC · Fort Smith, ARN3820XDwyhalo David W · Moorpark, CAN3820ZBudd Kirkland G · Rushville, NEN38211Watford Aeroservice LLC · Watford City, NDN38214Mora Steven T · Corning, CAN3821FKennedy Karen E · Gulf Breeze, FLN3821GI Am Alpha & Omega LLC · Sparks, NVN3821KSoar Above Flight Solutions LLC · Englewood, TNN3821PRadach Kenneth D · Copper Center, AKN3821TDoty David W · Lakeland, FLN38226Martinex Aviation LLC · Wentzville, MON3822DGifford David M · Las Vegas, NVN3822FBelser Mark · Avon, OHN3822KPerry Park Investments Inc · Larkspur, CON3822QMatanane Roke C · Barrigada, GUN3822TVanderblom David Y · Oxford, ALN3822URegistration Pending · Stillwater, MNRegistration pendingN3823AAndy Downs LLC · Langdon, NDN3823DPfaff John W · Laytonville, CAN3823FGovednik Francis J · Flower Mound, TXN3823WCherokee N3823w LLC · Huntsville, ALFirst renewal noticeN3823XRegistration Pending · Logan, UTRegistration pendingN3823ZFranks Cory B · Idalou, TX
Back to AD 2007-04-19 R1