OpenAirDocs.org
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.

N744TWTumbleweed Leasing Co Inc · Salt Lake City, UTFirst renewal noticeBuilt 2005 · S/N 10702N744VBRdcf Aviation LLC · Wilmington, DEBuilt 2017 · S/N 14090N744WARobinson Helicopter Co · Torrance, CAS/N 15039N744WGSpitzer Helicopter LLC · Wilmington, DES/N 11635N74500Lanier Equipment Leasing LLC · Gainesville, GABuilt 2005 · S/N 10792N74508Agricultural Tours LLC · Cheyenne, WYBuilt 2006 · S/N 1600N74543Sky Solutions LLC · Detroit, MIBuilt 2006 · S/N 11214N74563Black Bird Holdings LLC · Gilbert, AZBuilt 2006 · S/N 11045N745RGRio Grande Helicopters Inc · Laredo, TXBuilt 2012 · S/N 13323N74602November Alpha LLC · Dover, DEBuilt 2006 · S/N 11098N74637Equipment Leasing & Rental Inc · Wilmington, NCBuilt 2006 · S/N 11128N74651Echo Foxtrot Holdings LLC · Midway, UTBuilt 2005 · S/N 10822N74663Los Cazadores Aviation LLC · Cut Off, LABuilt 2005 · S/N 10842N74666Edmundson George · Hood River, ORBuilt 2005 · S/N 10845N74685Independent Helicopters LLC · New Windsor, NYBuilt 2005 · S/N 10936N74686Fly In Helicopters LLC · Wilmington, DEBuilt 2006 · S/N 11226N746BPSky Solutions LLC · Detroit, MIBuilt 2012 · S/N 13364N74730Twin Rivers Wildlife Inc · Elko, NVBuilt 2005 · S/N 10888N74767Emerald City Aircraft Leasing Inc · Port Orchard, WABuilt 2005 · S/N 10915N74784Executive Helicopters Inc · Myrtle Beach, SCBuilt 2005 · S/N 10925N74794Wojtowicz Tomasz · Bronx, NYBuilt 2005 · S/N 10944N747LFLewis Aeronautical LLC · San Antonio, TXBuilt 2022 · S/N 14592N747WDJohnston Philip M · Mountain Home, TXS/N 0460N74807Flying Fezent LLC · Almont, MIBuilt 2005 · S/N 10959N74808United Helicopter Leasing LLC · Honolulu, HIBuilt 2005 · S/N 10974N74836Lepping Kurt M · Wasilla, AKS/N 10981N74851Buell Travis · Harper, TXBuilt 2005 · S/N 11018N74868Sheep Mountain Air LLC · Sutton, AKS/N 11038N748BPNiehaus Michael J · West Burlington, IABuilt 2005 · S/N 10994N749TWTumbleweed Leasing Co Inc · Salt Lake City, UTBuilt 2004 · S/N 10582N74EHMccarly Brian · Uvalde, TXBuilt 2017 · S/N 14093N74EPCantrell Grady DBA · Los Banos, CABuilt 2013 · S/N 2301N74RGRio Grande Helicopters Inc · Laredo, TXBuilt 2016 · S/N 2453N74WHWf Aviation LLC · Grandview, WABuilt 2021 · S/N 14458N7507XGhgk LLC · Myrtle Beach, SCBuilt 2002 · S/N 1218N7508ZRotorwing LLC · Sheffield, ILBuilt 2005 · S/N 10609N750GTRegistration Pending · Bozeman, MTRegistration pending, pending cancellationBuilt 2007 · S/N 11783N7510TSpitzer Helicopter LLC · Woodland Hills, CABuilt 2006 · S/N 1563N7511WTtwn Media Networks LLC · New York, NYBuilt 2002 · S/N 1198N7512NNative Range Capture Services Inc · Elko, NVBuilt 2003 · S/N 10131N7513QFingerlakes Wing And Rotor LLC · Seneca Falls, NYS/N 10159N75175November Alpha LLC · Dover, DEBuilt 2003 · S/N 1331N7518DEros Aviation Ventures LLC · Oakland Park, FLS/N 10240N7518QFly For Fun LLC · Rockville, MDExpired dealerBuilt 2004 · S/N 10281N7519GStearns William W · Talkeetna, AKBuilt 2004 · S/N 1363N7523EFlying J Services LLC · Jourdanton, TXBuilt 2003 · S/N 1321N7523TNovember Alpha LLC · Dover, DEBuilt 2004 · S/N 10311N7524WN7524w LLC · Grand Ledge, MIBuilt 2003 · S/N 10176N7526LPcm Aviation LLC · Wilmington, DEBuilt 2004 · S/N 10286N7527GBatista Caleb · Danese, WVBuilt 2005 · S/N 10805
Back to AD 95-26-05 R1