OpenAirDocs.org
AD 85-25-07 R1

Registered aircraft · 624

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:85-25-07-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:85-25-07-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.

N355AEAir Evac Ems Inc · O Fallon, MOBuilt 2011 · S/N 52425N357SPLouisiana Department Of Public Safety · Baton Rouge, LABuilt 1996 · S/N 52161N35KHBlackbell 22 LLC · Wilmington, DEBuilt 2024 · S/N 0355FFN35NRCentral States Helicopters Inc · Wood River, NEBuilt 1995 · S/N 52137N361ALBillings Flying Service LLC · Billings, MTBuilt 1987 · S/N 51212N361DT925dt LLC · Picayune, MSBuilt 1994 · S/N 52080N361SHLima Whiskey LLC · Missoula, MTBuilt 1989 · S/N 0058FFN362ALMarks Lloyd · Lafayette, LABuilt 1991 · S/N 51471N367PDCity Of Atlanta · Atlanta, GABuilt 2023 · S/N 0344FFN369FFBank Of Utah Trustee · Salt Lake City, UTBuilt 2009 · S/N 0709FFN369TVTennessee Valley Authority · Muscle Shoals, ALBuilt 2017 · S/N 0269FFN36FGCalifornia Department Of Fish & Wildlife · Sacramento, CABuilt 2020 · S/N 0322FFN370DPDodson International Parts Inc · Rantoul, KSBuilt 1992 · S/N 51569N371PDCity Of Atlanta · Atlanta, GABuilt 2023 · S/N 0345FFN3777MRotor Co · New Braunfels, TXBuilt 1991 · S/N 51485N377LFHelicopter Parts International Inc · Minden, NVBuilt 1989 · S/N 51281N378JCLongranger IV LLC · Missoula, MTBuilt 2013 · S/N 52448N383SHAspen Helicopters Inc · Oxnard, CABuilt 1983 · S/N 51073N385RLSan Juan Aviation LLC · Wilmington, DEBuilt 2008 · S/N 52385N386VCCounty Of Volusia · Deland, FLBuilt 1996 · S/N 52179N388JCSweetwater Landing LLC · Helena, MTBuilt 1981 · S/N 45568N3893UMonarch Enterprises Inc · Kirkland, WAS/N 51020N3895DMonarch Enterprises Inc · Kirkland, WABuilt 1980 · S/N 45590N38BZHelicopters Inc · Wilmington, DEBuilt 1995 · S/N 52128N38THGlobal Aerials Inc · Pembroke Pines, FLS/N 45653N395AEAir Evac Ems Inc · O Fallon, MOS/N 45551N396RLMorris Equipment LLC · Yuma, AZBuilt 1980 · S/N 45-396N397RLBank Of Utah Trustee · Salt Lake City, UTBuilt 1980 · S/N 45397N399AETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2016 · S/N 52490N399MHBlade Leasing LLC · Homer, AKBuilt 1993 · S/N 52016N39LRHornet LLC · Picayune, MSBuilt 1981 · S/N 45654N3QYHelicopters Inc · Wilmington, DEBuilt 1999 · S/N 52224N401FNNy On Air LLC · Kearny, NJBuilt 1994 · S/N 52081N401FWFlorida Fish & Wildlife Conservation Commission · Lakeland, FLBuilt 2006 · S/N 52327N40290Haddock Flying Service Inc · Salters, SCBuilt 1980 · S/N HA3081N402AEAir Evac Ems Inc · O Fallon, MOBuilt 2009 · S/N 52393N402FWFlorida Fish & Wildlife Conservation Commission · Lakeland, FLBuilt 2006 · S/N 52328N402TDAir Metro Helicopters Inc · New City, NYBuilt 1990 · S/N 51383N4032YBank Of Utah Trustee · Salt Lake City, UTBuilt 1981 · S/N 5180N404AEAir Evac Ems Inc · O Fallon, MOBuilt 2011 · S/N 52434N404MPIndustrial Helicopters LLC · Lafayette, LABuilt 1994 · S/N 52083N405LPGm Leasing Co LLC · Broussard, LABuilt 1994 · S/N 52085N405RLGlobal Aviation Florida LLC · Pompano Beach, FLBuilt 1990 · S/N 51405N4068GGulf Coast Helicopters Inc · Pearland, TXBuilt 1968 · S/N 229N406KKKehler Kelly · Saint Xavier, MTBuilt 2004 · S/N 52283N406MPGm Leasing Co LLC · Broussard, LABuilt 1994 · S/N 52086N406WHHeli-Works Flight Services LLC · Deer Lodge, MTBuilt 1991 · S/N 51537N407AEAir Evac Ems Inc · O Fallon, MOBuilt 2009 · S/N 52409N407CCCounty Of Contra Costa · Martinez, CABuilt 1997 · S/N 53090N407CHClassic Medical Inc · North Salt Lake, UTBuilt 1996 · S/N 53011
Back to AD 85-25-07 R1