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.

N775BDAviation Advantage Inc · Tabor City, NCBuilt 1977 · S/N 970197D N782MHRotor Blade LLC · Pawleys Island, SCBuilt 1980 · S/N 600739D N7NPTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTS/N 0260E N801SBBank Of Utah Trustee · Salt Lake City, UTS/N 0209E N805MDIntegrity Aircaft Title Holdings LLC · Portland, ORBuilt 1986 · S/N 0168E N808BHNorton Basin Services · Nome, AKBuilt 1988 · S/N 0317E N808JHTreeline Helicopters Inc · Bristol, TNBuilt 2008 · S/N 0577E N809WAWindward Aviation Inc · Puunene, HIBuilt 1979 · S/N 490493D N811WAWindward Aviation Inc · Puunene, HIBuilt 1979 · S/N 590517D N81WHWarbirds-3 LLC · Kalispell, MTBuilt 2007 · S/N 0574E N828HKHawkeye Helicopter LLC · Lyndon, KSBuilt 1996 · S/N 0532E N8306FRotor Blade LLC · Georgetown, SCBuilt 1978 · S/N 380274D N8330PN24wd Capital Holdings LLC · Redding, CABuilt 1989 · S/N 0330E N8348FWestern Pacific Fisheries Inc · Las Vegas, NVS/N 1260051D N8353FRoyal Helicopter Services LLC · Exeter, CABuilt 1977 · S/N 1260062D N8356FPatriot Aviation Inc · Greenville, DES/N 1260063D N8357FTemsco Helicopters Inc · Ketchikan, AKS/N 170069D N8366FAa Leasing Lp · Kilauea, HIS/N 270082D N8371FBank Of Utah Trustee · Salt Lake City, UTBuilt 1990 · S/N 0399E N8372FCity Of Houston Police Department · Houston, TXBuilt 1991 · S/N 0488E N8373FI T A Services LLC · Westminster, MDBuilt 1993 · S/N 0511E N842JHJack Harter Helicopters Inc · Lihue, HIBuilt 1983 · S/N 0020E N843ATHlh Leasing LLC · Wilmington, DES/N 1100843 N845BHBering Air Inc · Nome, AKBuilt 2014 · S/N 0618E N8612FGulf Helicopters LLC · Santa Fe, TXBuilt 1977 · S/N 570142D N8617FUnited States Department Of Agriculture · Cedar City, UTBuilt 1977 · S/N 570128D N861MCQuicksilver Air Inc · Fairbanks, AKBuilt 1978 · S/N 980348D N862MCManatee County Mosquito Control District · Ellenton, FLBuilt 1980 · S/N 600724D N863MCQuicksilver Air Inc · Fairbanks, AKBuilt 1980 · S/N 1200879D N8648FVertol Systems Co Inc · Destin, FLBuilt 1978 · S/N 180257D N868WDah Aircraft LLC · Georgetown, SCBuilt 1980 · S/N 1000800D N869VSVertol Systems Co Inc · Destin, FLBuilt 1982 · S/N 1151D N86STAerial Solutions Inc · Tabor City, NCBuilt 1981 · S/N 711012D N888EVTop Flight Aviation Of Mississippi LLC · Picayune, MSBuilt 1985 · S/N 0152E N8969FTeryjon Aviation Inc · Bluefield, VABuilt 1978 · S/N 980344-D N907BHBering Air Inc · Nome, AKBuilt 2013 · S/N 0615E N90ALCherry Helicopters Inc · La Jolla, CABuilt 1978 · S/N 880321D N911BYAmerican Honor Foundation Inc · Melourne, FLBuilt 2013 · S/N 0617E N911CPSt Louis County Police Department · Clayton, MOBuilt 1984 · S/N 0105E N911HYHawaii County Fire Department · Hilo, HIBuilt 2010 · S/N 0602E 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 N9159FApex Heli-Support LLC · Phoenix, AZS/N 1090605D N915LYLyons Aircraft Leasing LLC · Hillsboro, ORBuilt 1989 · S/N 0350E 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 N926DDTurbine Flying Penguins LLC · Gardnerville, NVBuilt 1991 · S/N 0426E

Back to AD 84-12-01 R1