AD 2016-05-13
Registered aircraft · 3,126
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:2016-05-13')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2016-05-13')
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:2016-05-13') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2016-05-13') 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.
N9634BMec International Trading LLC · Daytona Beach, FLN963FEFederal Express Corp · Memphis, TNN963HLCaravan-International Leasing Inc · Carson City, NVN963KAMeshoppen Air LLC · Tunkhannock, PAN964LBCoastal Aviation Group LLC · Panama City, FLN9655BSkysno Aviation LLC · Snohomish, WAN965FEFederal Express Corp · Memphis, TNN965SBFlynn Dog Aviation LLC · Port Charlotte, FLN966FABoardman Air Service LLC · Henderson, NEN966FEFederal Express Corporation · Memphis, TNN966HLCaravan International Leasing Inc · Carson City, NVN967FEFederal Express Corporation · Memphis, TNN967HLCaravan International Leasing Inc · Carson City, NVN967TBJc Air Montana LLC · Missoula, MTN9680BCatalina Air Transport LLC · Long Beach, CAN968FEFederal Express Corporation · Memphis, TNN968LAC & L Holtzworth Inc · Virden, ILN969FEFederal Express Corporation · Memphis, TNN969JVGgm Transport LLC · Bakersfield, CAN969PLUS Government · Washington, DCN96CESummit Air Leasing LLC · Portage, MIN96FMYates Industries LLC · Artesia, NMN96KKPro Serve Aviation LLC · Englewood, CON970FEFederal Express Corporation · Memphis, TNN970GRjc Aviation LLC · Morrow, OHN970JMTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN970LAC&L Holzwarth Inc · Virden, ILN971FEFederal Express Corporation · Memphis, TNN971NUS Government · Washington, DCN971SCAxis Transportation Services LLC · Sacramento, CAN972AAAfab Capital LLC · Oak Creek, WIN972FEFederal Express Corporation · Memphis, TNN973AAAcc Integrated Services Inc · Milwaukee, WIN973FEFederal Express Corporation · Memphis, TNN973GACentral Virigina Aviation Inc · North Dinwiddie, VAN975TBMiles High Flight Assets LLC · Atlanta, GAN9760BMartinaire Aviation LLC · Addison, TXN9761BMartinaire Aviation LLC · Addison, TXN9762BMartinaire Aviation LLC · Addison, TXN9766BRedding Aero Enterprises Inc · Redding, CAN976EWright Air Service Inc · Fairbanks, AKN976FEFederal Express Corporation · Memphis, TNN976NMKlondike Ag LLC · Nassau, DEN977FEFederal Express Corporation · Memphis, TNN977JBJb Leasing LLC · Norfolk, NEN977RMBretts Spray Service Inc · Onida, SDN978JGColorado Orthopaedic Outreach Inc · Steamboat Springs, CON978TSWaxhaw Flyers LLC · Rosedale, MSN979DKCatia Resources LLC · Garden City, TXN979FEFederal Express Corp · Memphis, TN
Back to AD 2016-05-13