Registered aircraft · 563

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:84-24-54-R2') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:84-24-54-R2') 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:84-24-54-R2')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:84-24-54-R2')
  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:84-24-54-R2')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:84-24-54-R2')
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.

N803BAWildwest Helicopters Inc · Henderson, NVBuilt 1995 · S/N 52153 N808HLRegistered aircraftN-number assigned, not yet registeredS/N 51581 N811SFN179sf LLC · Chandler, AZBuilt 1994 · S/N 52070 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 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 N95TVHelicopters Inc · Wilmington, DEBuilt 2005 · S/N 52316 N965RWWilmarth Russell · Alton Bay, NHBuilt 2002 · S/N 5047 N969MSWhirlwide Inc · Fresno, CABuilt 2025 · S/N 0239E N96BHBighorn Flying Co LLC · Wood River, NEBuilt 1982 · S/N 51011 N96KBHlh Leasing LLC · Wilmington, DEBuilt 1989 · S/N 0608FF N970QHeli Works Flight Services LLC · Deer Lodge, MTBuilt 1988 · S/N 51255 N970YGCbk LLC · Eagle, COBuilt 1979 · S/N P21000219 N974RHTurbines Ltd · West Point, NEBuilt 1994 · S/N 23020

Back to AD 84-24-54 R2