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

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

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.

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

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.

N79TMAbove & Beyond Aviation Inc · Anchorage, AKBuilt 1991 · S/N 51472 N79TVBank Of Utah Trustee · Salt Lake City, UTBuilt 1982 · S/N 45718 N7QNHelicopters Inc · Wilmington, DEBuilt 1997 · S/N 52199 N7YJHelicopters Inc · Linden, NJS/N 52026 N801CLAv8-Orr Helicopter Services Inc · Hamilton, MTBuilt 1979 · S/N 45354 N803BAWildwest Helicopters Inc · Henderson, NVBuilt 1995 · S/N 52153 N808HLRegistered aircraftN-number assigned, not yet registeredS/N 51581 N8118YSanborn Richard E Trustee · Bethlehem, NHS/N 2017 N811SFN179sf LLC · Chandler, AZBuilt 1994 · S/N 52070 N828KBAmerican Business Aircraft LLC · Dover, DES/N 23014 N828WPBas Part Sales LLC · Greeley, COBuilt 1979 · S/N 45294 N83LPPanther Helicopters Inc · Belle Chasse, LABuilt 1994 · S/N 52075 N83UHelicopters Inc · Wilmington, DEBuilt 1995 · S/N 52124 N852SSAg Air Inc · Johnstown, COS/N 51270 N853SSTippmann Choppers LLC · Fort Wayne, INBuilt 1980 · S/N 45584 N860MCManatee County Mosquito Control District · Ellenton, FLBuilt 1992 · S/N 0086FF N86PHProvine Helicopter Service Inc · Greenwood, MSBuilt 1991 · S/N 51436 N87JRRoche Gerald Aloysius · KildareBuilt 2004 · S/N 52291 N87WPMarks Lloyd L · Lafayette, LABuilt 1992 · S/N 52011 N882TVTennessee Valley Authority · Muscle Shoals, ALBuilt 2020 · S/N 0324FF N886AEAir Evac Ems Inc · O Fallon, MOBuilt 2016 · S/N 52486 N887AETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2016 · S/N 52487 N888SWSeawind Mjw LLC · Wappingers Falls, NYBuilt 2005 · S/N 60 N88AEAir Evac Ems Inc · O Fallon, MOBuilt 2014 · S/N 52457 N88BDSouthern Illinois Helicopters LLC · Marion, ILBuilt 2004 · S/N 52285 N8BQBank Of Utah Trustee · Salt Lake City, UTBuilt 1984 · S/N 51108 N900FFRmb Helicopters LLC · Newark, DEBuilt 1994 · S/N 0100FF N902EHNorth Wind Aviation LLC · Chelan, WAS/N 45769 N9047CHenderson Aviation Co · Junction City, ORBuilt 1997 · S/N 52201 N904CMRepublic Helicopters Inc · Santa Fe, TXBuilt 1993 · S/N 23013 N90EVTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1984 · S/N 760264 N90MPState Of Missouri · Jefferson City, MOBuilt 1990 · S/N 4113 N91018Two Wise Guys Aviation LLC · Le Sueur, MNBuilt 1965 · S/N 3558 N910BRAir Gov 1 LLC · Rome, NYBuilt 2004 · S/N 52294 N911EALarson Michael A · Perham, MNBuilt 1983 · S/N 51039 N911HKCounty Of Kauai-Fire Department · Lihue, HIBuilt 2009 · S/N 0173FF N911VBCity Of Virginia Beach · Virginia Beach, VABuilt 2017 · S/N 0270FF N911WYLas Vegas Metropolitan Police Department · North Las Vegas, NVBuilt 2000 · S/N 0144FF N911YYCity Of Chicago · Chicago, ILBuilt 1993 · S/N 52047 N91XAXtreme Aviation LLC · Falkville, ALBuilt 1991 · S/N 51438 N920FCFresno County Sheriff Dept · Fresno, CABuilt 2016 · S/N 0255FF N9245CCh4 Systems LLC · Guaynabo, PRBuilt 2006 · S/N 52331 N92PJWw Flying Services LLC · Waller, TXBuilt 1984 · S/N 51094 N941SHSummit Helicopters Inc · Salem, VABuilt 1998 · S/N 52205 N946CBRhl Aviation LLC · Montrose, PABuilt 2011 · S/N 52427 N94HPPila LLC · Heber City, UTBuilt 1999 · S/N 52218 N951CPCity Of Cleveland · Cleveland, OHBuilt 2000 · S/N 0549E N952CPCity Of Cleveland · Cleveland, OHBuilt 2000 · S/N 0547E N95ALLakeland Aircraft Maintenance LLC · Eagle Lake, FLBuilt 1990 · S/N 51360 N95PDBeck Aviation LLC · Fort Myers, FLBuilt 1998 · S/N 52206

Back to AD 85-25-07 R1