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.
N783TAS2 Helicopter Services LLC · Albany, TXN783TYThings That Fly LLC · Wilmington, DEN784AKR44 Leasing LLC · Anchorage, AKN785AKAlpha Aviation LLC · Anchorage, AKN785WPrbi LLC · Catano, PRN786AKAlpha Aviation LLC · Anchorage, AKN787AJHawaii Pacific Aviation Inc · Kailua Kona, HIN788AJHawaii Pacific Aviation Inc · Kailua Kona, HIN788GCharlotte Helicopters Inc · Waxhaw, NCN788TKRudd Wayne G · Basalt, CON789GRH Richardson & Sons LLC · Ogdensburg, NYN789KBRotorwing LLC · Sheffield, ILN78FTTrl Aviation LLC · Little Rock, ARN791AKAlpha Aviation LLC · Anchorage, AKN7921CRomeo Whiskey LLC · Girdwood, AKN792CCGavranovic William J Sr · Wharton, TXN794YTNovember Alpha LLC · Dover, DEN797DMLightner Gerald · Garden City, KSN797WBMartin Earl · Seneca Falls, NYN798MGlobal Aerials Inc · Pembroke Pines, FLN79RHNowling Daryl · Palm City, FLN7QHPfannenschwarz Harry · Odessa, FLN800PRUhi Inc · Provo, UTN801SZBlue Stem Leasing LLC · Omaha, NEN801TVSky Helicopters Inc · Garland, TXN8035Sparta Rotors Inc · Stuyvesant, NYN803PTHeli Good Time LLC · Chesterfield, MIN804NVMoody Bible Institute Of Chicago · Spokane, WAN805GBGary Boyd Farms · Pearsall, TXN805HDShokoohi Mehdi · Anaheim, CAN806BCBravo Charlie LLC · Auburn, CAN806NVFlight Operations Inc · Lewes, DEN807LELeading Edge Flight Academy LLC · Bend, ORN807NVUnited Helicopter Leasing LLC · Honolulu, HIN808AFlying Mermaid LLC · Aiea, HIN808JTVu Ai T · Aiea, HIN808LBUnited Therapeutics Corp · Silver Spring, MDN808LLApex Helicopters LLC · Pearland, TXN808WHNext Level Land Sales LLC · Zolfo Springs, FLN808WTSchool Board Of Leon County Florida · Tallahassee, FLN810BKMccr LLC · Anchorage, AKN81191Castor Aviation Ltd · Wasilla, AKN811SSmith Helicopters Inc · Cotulla, TXN812BZAloha Helicopter Tours LLC · Lihue, HIN813MWIndependent Helicopters LLC · New Windsor, NYN814RLNicholson Aviation Co LLC · Normandy Park, WAN814SCMetroplex Flight Services LLC · Fort Worth, TXN815JHHeligroup LLC · Wilmington, DEN816WMRent A Copter LLC · Homer Glen, ILN817PTSundance Aero LLC · Mertzon, TX
Back to AD 95-26-05 R1