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.

N9118FCook Jeffrey G Trustee · Ventura, CABuilt 1972 · S/N 720397S N911BYAmerican Honor Foundation Inc · Melourne, FLBuilt 2013 · S/N 0617E N911CPSt Louis County Police Department · Clayton, MOBuilt 1984 · S/N 0105E N911HUUsda Aphis Ws Atoc · Cedar City, UTS/N 191001 N911HYHawaii County Fire Department · Hilo, HIBuilt 2010 · S/N 0602E N911JXSt Louis County Police · Chesterfield, MOS/N 601424 N911MUSt Louis County Police Dept · Clayton, MOBuilt 2012 · S/N 0614E N911NYSt Louis County (Mo) Police Dept · Chesterfield, MOBuilt 2009 · S/N 0599E N911PHSt Louis County Police Department · Clayton, MOBuilt 1987 · S/N 0217E N9132FHorizon Aviation LLC · Glastonbury, CTBuilt 1973 · S/N 230446S N9146FBerling Robert E · Mooresville, INBuilt 1973 · S/N 830508S N9159FApex Heli-Support LLC · Phoenix, AZS/N 1090605D N915LYLyons Aircraft Leasing LLC · Hillsboro, ORBuilt 1989 · S/N 0350E N9166FNorthstar Marine LLC · Lewes, DEBuilt 1973 · S/N 830510S N9176F76f LLC · Calhoun, GABuilt 1974 · S/N 340569S N9177FRotor View Inc · Wilmington, DEBuilt 1973 · S/N 430465S N9196FAsbill Jimmy T · Winnsboro, TXBuilt 1974 · S/N 740616S N9204UAnduril Industries · Costa Mesa, CAS/N 0531E N920JPKar Aviation LLC · Saltville, VAS/N 290449D N921SDCounty Of Fresno · Fresno, CABuilt 1990 · S/N 0428E N922SDCounty Of Fresno · Fresno, CABuilt 1991 · S/N 0478E N9233FC & D Helicopters LLC · Spanish Fork, UTBuilt 1975 · S/N 350715S N9260FRjo LLC · Kenansville, FLBuilt 1975 · S/N 450741S N9267FManulwa Airways Inc · Hilo, HIBuilt 1975 · S/N 1150778S N926DDTurbine Flying Penguins LLC · Gardnerville, NVBuilt 1991 · S/N 0426E N926ESRoyal Helicopter Services LLC · Exeter, CABuilt 1974 · S/N 940641S N9276FHeli-Flite Inc · Corona, CABuilt 1978 · S/N 180254D N935MAlan Aviation LLC · Los Angeles, CAS/N 1111125D N93MDNew Horizons Helicopters Inc Trustee · Wilmington, DEBuilt 1993 · S/N 0512E N9413FHelicopter Minit Men Inc · Columbus, OHBuilt 1978 · S/N 1180379D N9460TEvermore Aviation LLC · Wasilla, AKBuilt 1988 · S/N 0238E N951CPCity Of Cleveland · Cleveland, OHBuilt 2000 · S/N 0549E N952CPCity Of Cleveland · Cleveland, OHBuilt 2000 · S/N 0547E N952SFRegistration Pending · Elko, NVRegistration pendingBuilt 1989 · S/N 0366E N9677NDat Aircraft LLC · Lewes, DEBuilt 1974 · S/N 1020422S N969MSWhirlwide Inc · Fresno, CABuilt 2025 · S/N 0239E N969VSVertol Systems Co Inc · Destin, FLBuilt 1980 · S/N 1100833D N9792SGrand Haven Aviation Services · Spring Lake, MIBuilt 1966 · S/N 1060007 N98369Diamond X LLC · Elko, NVS/N 109-0114S N985MVKar Aviation LLC · Saltville, VAS/N 610985D N988DFCounty Council Of Beaufort County South Carolina · Beaufort, SCBuilt 1980 · S/N 700737D N98CPBank Of Utah Trustee · Salt Lake City, UTBuilt 1985 · S/N 0155E N990SRBlue Penguin LLC · Lockhart, TXBuilt 1973 · S/N 230452S N991MCCharleston County Mosquito Control · North Charleston, SCBuilt 1978 · S/N 780314D N992MCCharleston County Mosquito Control · North Charleston, SCBuilt 1978 · S/N 1080363D N99888Combat Rotors LLC · Eugene, ORBuilt 1969 · S/N 391105 N998SHConstruction Equipment Rentals Inc · Fallbrook, CABuilt 1980 · S/N 1100847D N9HAMiracle Robert B Sr · Perkasie, PABuilt 1973 · S/N 730503S

Back to AD 84-01-02 R1