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.

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 N818SCHartland Helicopters LLC · Edinburg, TXBuilt 1967 · S/N 770093 N81WHWarbirds-3 LLC · Kalispell, MTBuilt 2007 · S/N 0574E N822LJCaribe Helicopters Inc · Coral Gables, FLBuilt 1972 · S/N 120367S N828HKHawkeye Helicopter LLC · Lyndon, KSBuilt 1996 · S/N 0532E N8305FDel Rio Aviation Inc · Paso Robles, CAS/N 160782S N8306FRotor Blade LLC · Georgetown, SCBuilt 1978 · S/N 380274D N8330PN24wd Capital Holdings LLC · Redding, CABuilt 1989 · S/N 0330E N8345FAisling Developments LLC DBA · Calhoun, GAS/N 1050774S 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 N8388FUsda Aphis Ws Atoc · Cedar City, UTS/N 760838S 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 N865HSRoyal Helicopter Services LLC · Exeter, CABuilt 1977 · S/N 1060865S 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 N888DXAlexander Mary · Grants Pass, ORBuilt 1968 · S/N 380362 N888EVTop Flight Aviation Of Mississippi LLC · Picayune, MSBuilt 1985 · S/N 0152E N888USAm Air Service LLC · Green Oaks, ILBuilt 1968 · S/N 180282 N8969FTeryjon Aviation Inc · Bluefield, VABuilt 1978 · S/N 980344-D N9010FCody Richard A · Mclean, VABuilt 1969 · S/N 190004 N9016FHigh Shines Inc · Earl Park, INBuilt 1969 · S/N 890111S N9020FSideline Services LLC · Pearland, TXBuilt 1969 · S/N 1090203E N9034FStuart Aviation Inc · Wilmington, DEBuilt 1969 · S/N 790105S N9052FMotivated Air LLC · Felton, DEBuilt 1970 · S/N 1290225S N907BHBering Air Inc · Nome, AKBuilt 2013 · S/N 0615E N90ALCherry Helicopters Inc · La Jolla, CABuilt 1978 · S/N 880321D N9107FUp Rite Aviation LLC · Zeeland, MIBuilt 1972 · S/N 320370S N9113QSea Corp Helicopters Inc · Wilmington, DEBuilt 1976 · S/N 260794S N9117HBrown Helicopter Inc · Pensacola, FLBuilt 1969 · S/N 791239

Back to AD 84-01-02 R1