Registered aircraft · 498

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-01-02-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-01-02-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-01-02-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-01-02-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-01-02-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-01-02-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.

N369HSPurcell Ian · San Diego, CABuilt 1976 · S/N 850763S 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 N369KECbft LLC · Mobile, ALBuilt 1969 · S/N 991271 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 N369NKButler Aviation Investments LLC · Tonopah, AZBuilt 1972 · S/N 520385S 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 N369ZMHelios Helicopters LLC · Clackamas, ORS/N 1000259S N36KRDragonfly Aviation LLC · Mirando City, TXBuilt 1978 · S/N 580315D N3766ZBanfield Patrick C · Frazier Park, CABuilt 1974 · S/N 440588S N377LWPremier Helicopters LLC · Kalispell, MTS/N 0523E N383FJ&J Holdings And Investments LLC · Phoenix, AZBuilt 1990 · S/N 0440E N387RFMid America Flight Museum · Mount Pleasant, TXBuilt 1969 · S/N 301381 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 N411AFTeryjon Aviation Inc · Bluefield, VABuilt 1974 · S/N 1040657S N411JHHeidrick Joe · Woodland, CAS/N 0193E N411WJNorthwest 60 LLC · Kalispell, MTBuilt 2014 · S/N 0620E N415WCWilson Construction Co · Canby, ORBuilt 1981 · S/N 0005E N41776Warbirds-3 LLC · Kalispell, MTBuilt 1967 · S/N 1080820 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 N4337BBatto John H · Carson City, NVS/N 580496 N445SAvitek Inc · Plymouth, MIS/N 230445S N4467VWilson Robert B · Superior, AZS/N 120363S N450AGInternational Air Services Inc Trustee · Carson City, NVBuilt 1971 · S/N 1090202M N451HAIron Horse Aviation LLC · Marshalltown, IABuilt 1979 · S/N 490484D N454JHJack Harter Helicopters Inc · Lihue, HIBuilt 1991 · S/N 0454E N45780Nelson Aviation LLC · Crown Point, INBuilt 1969 · S/N 65-12968 N457GMCentury Aviation Inc Trustee · Wilmington, DEBuilt 2010 · S/N 0603E

Back to AD 84-01-02 R1