AD 95-26-05 R1
Registered aircraft · 1,944
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:95-26-05-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:95-26-05-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:95-26-05-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:95-26-05-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.
N59KCSouthern Aircraft Consultancy Inc Trustee · Casper, WYN5FQBlue River Heli LLC · Anchorage, AKN600EPKdm Services LLC · Wilmington, DEN600SRCsd Enterprises Inc · Wilmington, DEN600UHN600uh LLC · San Juan, PRN601BWBw'S Vertical Adventures LLC · Meridian, MSN601KAChavi LLC · Fredericksburg, TXN601TVOrlando Aircraft Sales LLC · Orlando, FLN603JM603jm LLC · Laconia, NHN604JAVeracity Aviation LLC · Seguin, TXN606TSAircraft Guaranty Corp Trustee · Oklahoma City, OKN608GBAircraft Management Group Intl Corp Trustee · Wilmington, DEN608HRJc Aircraft Leasing LLC · Wasilla, AKN60FMArmstrong Helicopters LLC · Laredo, TXN60HCKing Winn K · Gladewater, TXN60HTApex Helicopters LLC · Pearland, TXN60LECuruchet Shay · Kaycee, WYN611THK M A Leasing · Salinas, CAN611XBravo One LLC · Saint Louis, MON612GGMid Missouri Spray Service LLC · Richmond, MON616NCCedar Ridge Aviation LLC · Knox City, TXN616NWNgw Executive Transport Lp · Wimauma, FLN616RHangar 21 Aviation Inc · Orange, CAN617JLHeli Concepts LLC · Austin, TXN619BZFp Trans LLC · San Angelo, TXN619HJPaden Brian David · Wasilla, AKN619RBNovember Alpha LLC · Dover, DEN619RFJameshmp Enterprises LLC · Lockport, ILN619TVOrlando Aircraft Sales LLC · Orlando, FLN61CHSanstone Aviation LLC · Arden, NCN61KG2 G Group LLC · Honolulu, HIN61MMCbhelos LLC · Chesapeake, VAN61MXTj Aviation LLC · Blackfoot, IDN61TMElliott Randy K · Wasilla, AKN620GGHsgr Sky Rental LLC · San Juan, PRN621JLCertavi Aircraft Leasing LLC · Franklin, TNN622Chambliss Aerobatics LLC · Chandler, AZN624WCRs Aviation Services · Moorpark, CAN625HTHi Tech Helicopters · Tobyhanna, PAN625LGMid South Helicopters LLC · Morris Chapel, TNN627RWHudson Ronnie · Miles, TXN627VJDeer Creek Cattle Co · Dalhart, TXN629RWDrew Helicopters LLC · Annona, TXN629WTMidwest Aircraft Sales LLC · Lincoln, NEN62CDSavant Aviation LLC · Kinder, LAN62GFAirman Helicopter Inc · Fort Lauderdale, FLN62RKBailey Zachary · Xenia, ILN630GGOzark Air Operations LLC · Kansas City, MON630MSHelicrop LLC · Menlo, IAN632NSStella Air Inc · Wyoming, PA
Back to AD 95-26-05 R1