Registered aircraft · 366

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-12-01-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:84-12-01-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:84-12-01-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:84-12-01-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:84-12-01-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:84-12-01-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.

N369EHApplebee Aviation Inc · Banks, ORBuilt 1980 · S/N 1200861D N369FCFerguson And Sons Construction LLC · Emmett, IDBuilt 1981 · S/N 610983D N369JHJack Harter Helicopters Inc · Lihue, HIBuilt 1985 · S/N 0145E N369JVAviation Advantage Inc · Tabor City, NCS/N 0334E N369KDDairy Air LLC · Scottsdale, AZBuilt 1983 · S/N 0037E N369KVAgricultural Air Services LLC · Jupiter, FLBuilt 1980 · S/N 300659D N369LRCenterline Holdings Inc · Camden, DES/N 610991D N369MHAa Leasing Lp · Kilauea, HIBuilt 1978 · S/N 380287D N369MPAviation Advantage Inc · Tabor City, NCBuilt 1977 · S/N 670150D N369PBHelicopter Aviation Services & Leasing Inc · Miami, FLBuilt 1978 · S/N 480305D N369SCVertical Flight Path LLC · Wilmington, DES/N 380273D N369SDPyramid Property Development And Management LLC · Cedar Lake, INBuilt 2000 · S/N 0548E N369TAHva Inc · Summersville, WVBuilt 1996 · S/N 0529E N369TRChehalem Helicopters LLC · Newberg, ORBuilt 1977 · S/N 570141D N369WYReece Construction Company · Marysville, WABuilt 1981 · S/N 510976D N36KRDragonfly Aviation LLC · Mirando City, TXBuilt 1978 · S/N 580315D N377LWPremier Helicopters LLC · Kalispell, MTS/N 0523E N383FJ&J Holdings And Investments LLC · Phoenix, AZBuilt 1990 · S/N 0440E N40090Bank Of Utah Trustee · Salt Lake City, UTS/N 0627E N400MBPrecision Heli-Support LLC · Mesa, AZBuilt 1990 · S/N 0420E N4010RBank Of Utah Trustee · Salt Lake City, UTS/N 0628E N40125N525gm LLC · Bozeman, MTBuilt 2020 · S/N 0625E N4037LSouthern Aircraft Consultancy Inc Trustee · Casper, WYS/N 0589E N405ATRotor Blade LLC · Georgetown, SCBuilt 1980 · S/N 500717D N411JHHeidrick Joe · Woodland, CAS/N 0193E N411WJNorthwest 60 LLC · Kalispell, MTBuilt 2014 · S/N 0620E N415WCWilson Construction Co · Canby, ORBuilt 1981 · S/N 0005E N41AJEnglish Air Service LLC · Georgetown, TXBuilt 1978 · S/N 480299D N420KTRegistered aircraftBuilt 2008 · S/N 0582E N420WCWilson Construction Company · Canby, ORS/N 0579E N421KY250 Logistics LLC · Mount Pleasant, TXBuilt 2009 · S/N 0594E N421VSVertol Systems Company Inc · Destin, FLS/N 1090592D N425WCWilson Construction Co Inc · Canby, ORS/N 0268E N4265JRatcliff Dustin · Saltville, VABuilt 1979 · S/N 790542D N4292DUrocopters Inc · Lancaster, CAS/N 0364E N42FFBeef Aviation LLC · Bradenton, FLBuilt 1984 · S/N 0141E N451HAIron Horse Aviation LLC · Marshalltown, IABuilt 1979 · S/N 490484D N454JHJack Harter Helicopters Inc · Lihue, HIBuilt 1991 · S/N 0454E N457GMCentury Aviation Inc Trustee · Wilmington, DEBuilt 2010 · S/N 0603E N458HWHeliwild Investments LLC · Austin, TXBuilt 1979 · S/N 390483D N458PBBarbaro Paul G · Argyle, TXBuilt 1985 · S/N 0123E N46662Brown Helicopter Inc · Pensacola, FLBuilt 1979 · S/N 590510D N469FCFerguson And Sons Construction LLC · Emmett, IDBuilt 1980 · S/N 1100854D N46EEUnited States Department Of Agriculture · Cedar City, UTBuilt 1990 · S/N 0406E N473EOchoco Wood Products LLC · Prineville, ORBuilt 1991 · S/N 0473E N484Bhh Leasing #2 LLC · Pensacola, FLS/N 870177D N48MPPope James D · Lewiston, IDBuilt 1982 · S/N 1137D N499SLHlh Leasing LLC · Wilmington, DEBuilt 1979 · S/N 190448D N49WKRail N LLC · Oracle, AZBuilt 1981 · S/N 611006D N500ARHelicopter Roundup Service LLC · Nephi, UTS/N 0149E

Back to AD 84-12-01 R1