Registered aircraft · 484

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:2002-13-05-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:2002-13-05-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:2002-13-05-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:2002-13-05-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:2002-13-05-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:2002-13-05-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.

N734SLLaroche Aviation Services LLC · Bellaire, OHBuilt 1981 · S/N 911027D N735CBChesapeake Bay Helicopters Inc · Chesapeake, VABuilt 1980 · S/N 1100858D N73WLLaroche Aviation Services LLC · Bellaire, OHBuilt 1990 · S/N 0081FF N743MHDah Aircraft LLC · Georgetown, SCBuilt 1981 · S/N 811034D N748CBCbhelos LLC · Chesapeake, VABuilt 1988 · S/N 0303E N757TBWhite Bird LLC · Campobello, SCS/N 0166E N765BWHva Inc · Summersville, WVBuilt 1980 · S/N 200661D N765KVWinco Inc · Aurora, ORBuilt 1984 · S/N 0082E N774CBCbhelos LLC · Chesapeake, VABuilt 1983 · S/N 0016E 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 N860MCManatee County Mosquito Control District · Ellenton, FLBuilt 1992 · S/N 0086FF 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 N882TVTennessee Valley Authority · Muscle Shoals, ALBuilt 2020 · S/N 0324FF N888EVTop Flight Aviation Of Mississippi LLC · Picayune, MSBuilt 1985 · S/N 0152E N8969FTeryjon Aviation Inc · Bluefield, VABuilt 1978 · S/N 980344-D N900FFRmb Helicopters LLC · Newark, DEBuilt 1994 · S/N 0100FF 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

Back to AD 2002-13-05 R1