Registered aircraft · 1,083

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:83-03-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:83-03-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:83-03-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:83-03-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:83-03-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:83-03-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.

N407GHRotorcraft Support Inc · Fillmore, CABuilt 1996 · S/N 53075 N407KBOrange County Sheriffs Office · Orlando, FLBuilt 1997 · S/N 53146 N407PRWindsock Managmement LLC · Little Rock, ARBuilt 1997 · S/N 53162 N407RVHelicopter Services Of Illinois LLC · Fisher, ILBuilt 1982 · S/N 3621 N407UTMed Trans Corp · Denton, TXBuilt 1996 · S/N 53036 N4088YDumont Associates · Morris Plains, NJBuilt 1990 · S/N 4088 N40DVNordstrom Eric Trustee · Anchorage, AKBuilt 1982 · S/N U20606493 N40MCScotts Helicopter Service · Le Sueur, MNBuilt 1970 · S/N 563 N410SCAlfheim II LLC · Menomonee Falls, WIBuilt 1998 · S/N 5026 N411JHHeidrick Joe · Woodland, CAS/N 0193E N411WJNorthwest 60 LLC · Kalispell, MTBuilt 2014 · S/N 0620E N4155KPereira Alfred R Jr · Valley Springs, CAS/N 1053 N415WCWilson Construction Co · Canby, ORBuilt 1981 · S/N 0005E N41AJEnglish Air Service LLC · Georgetown, TXBuilt 1978 · S/N 480299D N41EWMemphis Police Department · Memphis, TNBuilt 1989 · S/N 4044 N41PHTobler Hans P · Anchorage, AKBuilt 1974 · S/N 1544 N41WEEastward Aviation Inc · Eagle Lake, TXS/N 3850 N420KTRegistered aircraftBuilt 2008 · S/N 0582E N420WPQualitair LLC Trustee · MichelstadtBuilt 2002 · S/N 29004C N421KY250 Logistics LLC · Mount Pleasant, TXBuilt 2009 · S/N 0594E N421SPKentucky State Police · Frankfort, KYBuilt 2008 · S/N 0714FF N4237MTrideca Vertical Solutions LLC · Dallas, TXBuilt 1989 · S/N 4055 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 N42LHFly Hangar 13 LLC · Mico, TXBuilt 1981 · S/N EA-163 N430AGMcmahon Helicopter Services Inc · Canton, MIBuilt 1998 · S/N 49045 N430JRAircraft Holding Solutions LLC Trustee · Newark, DEBuilt 1991 · S/N 7640 N430NYMcmahon Helicopter Services Inc · Canton, MIBuilt 2000 · S/N 49068 N430STHigh Performance Helicopters Corp · Crestline, CABuilt 2000 · S/N 49071 N430VPAerotrust Services Corp Trustee · Wilmington, DES/N 49005 N43142Scotts Helicopter Services Inc · Le Sueur, MNBuilt 1977 · S/N 1577 N431CAChem-Air LLC · Shreveport, LABuilt 1978 · S/N 2517 N431HFHeliflite Shares LLC · Newark, NJBuilt 1999 · S/N 49051 N432RDAirdine LLC · San Francisco, CABuilt 2002 · S/N 5039 N432TVSky Choppers LLC · Seneca, KSBuilt 1981 · S/N 3286 N43HHJohnson Flying Service LLC · Exira, IABuilt 1975 · S/N 1585 N43MAMinuteman Aviation Inc · Missoula, MTBuilt 1991 · S/N 4156 N441EAEdgefield Aviation LLC · Sandy, ORBuilt 1972 · S/N 71-20860 N4445HBell Textron Inc · Fort Worth, TXBuilt 1998 · S/N 4493 N444JBAir First LLC · Pembroke, NHBuilt 1971 · S/N 71-20362 N444TVScotts Helicopter Service Inc · Le Sueur, MNBuilt 1981 · S/N 3501 N445Wisk Aero LLC · Mountain View, CABuilt 1993 · S/N 4285 N4452Bravo Aviation LLC · Chicago, ILBuilt 1973 · S/N 1086 N445SAvitek Inc · Plymouth, MIS/N 230445S N448EAEdgefield Aviation LLC · Sandy, ORBuilt 1974 · S/N 1495 N450AGInternational Air Services Inc Trustee · Carson City, NVBuilt 1971 · S/N 1090202M N450XPlane Enjoyment LLC · Dover, MABuilt 1990 · S/N 12001C N451HAIron Horse Aviation LLC · Marshalltown, IABuilt 1979 · S/N 490484D

Back to AD 83-03-02 R1