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.

N369SDPyramid Property Development And Management LLC · Cedar Lake, INBuilt 2000 · S/N 0548E N369TAHva Inc · Summersville, WVBuilt 1996 · S/N 0529E N369TRChehalem Helicopters LLC · Newberg, ORBuilt 1977 · S/N 570141D N369TVTennessee Valley Authority · Muscle Shoals, ALBuilt 2017 · S/N 0269FF N369WYReece Construction Company · Marysville, WABuilt 1981 · S/N 510976D N36FGCalifornia Department Of Fish & Wildlife · Sacramento, CABuilt 2020 · S/N 0322FF N36KRDragonfly Aviation LLC · Mirando City, TXBuilt 1978 · S/N 580315D N371PDCity Of Atlanta · Atlanta, GABuilt 2023 · S/N 0345FF N377LWPremier Helicopters LLC · Kalispell, MTS/N 0523E N383FJ&J Holdings And Investments LLC · Phoenix, AZBuilt 1990 · S/N 0440E N40090Bank Of Utah Trustee · Salt Lake City, UTS/N 0627E N400MBPrecision Heli-Support LLC · Mesa, AZBuilt 1990 · S/N 0420E N4010RBank Of Utah Trustee · Salt Lake City, UTS/N 0628E N40125N525gm LLC · Bozeman, MTBuilt 2020 · S/N 0625E N4037LSouthern Aircraft Consultancy Inc Trustee · Casper, WYS/N 0589E N405ATRotor Blade LLC · Georgetown, SCBuilt 1980 · S/N 500717D N411JHHeidrick Joe · Woodland, CAS/N 0193E N411WJNorthwest 60 LLC · Kalispell, MTBuilt 2014 · S/N 0620E N415WCWilson Construction Co · Canby, ORBuilt 1981 · S/N 0005E N41AJEnglish Air Service LLC · Georgetown, TXBuilt 1978 · S/N 480299D N420KTRegistered aircraftBuilt 2008 · S/N 0582E N420WCWilson Construction Company · Canby, ORS/N 0579E N421KY250 Logistics LLC · Mount Pleasant, TXBuilt 2009 · S/N 0594E N421SPKentucky State Police · Frankfort, KYBuilt 2008 · S/N 0714FF N421VSVertol Systems Company Inc · Destin, FLS/N 1090592D N424WCWilson Construction Co · Canby, ORBuilt 1988 · S/N 0606FF 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 N451HAIron Horse Aviation LLC · Marshalltown, IABuilt 1979 · S/N 490484D N454JHJack Harter Helicopters Inc · Lihue, HIBuilt 1991 · S/N 0454E N457GMCentury Aviation Inc Trustee · Wilmington, DEBuilt 2010 · S/N 0603E N458HWHeliwild Investments LLC · Austin, TXBuilt 1979 · S/N 390483D N458PBBarbaro Paul G · Argyle, TXBuilt 1985 · S/N 0123E N46662Brown Helicopter Inc · Pensacola, FLBuilt 1979 · S/N 590510D N469FCFerguson And Sons Construction LLC · Emmett, IDBuilt 1980 · S/N 1100854D N46EEUnited States Department Of Agriculture · Cedar City, UTBuilt 1990 · S/N 0406E N473EOchoco Wood Products LLC · Prineville, ORBuilt 1991 · S/N 0473E N484Bhh Leasing #2 LLC · Pensacola, FLS/N 870177D N48MPPope James D · Lewiston, IDBuilt 1982 · S/N 1137D N499SLHlh Leasing LLC · Wilmington, DEBuilt 1979 · S/N 190448D N49WKRail N LLC · Oracle, AZBuilt 1981 · S/N 611006D N4RRBlue Sky Air Services LLC · Wilmington, DEBuilt 2013 · S/N 0203FF N500ARHelicopter Roundup Service LLC · Nephi, UTS/N 0149E N500BHAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1998 · S/N 0537E N500DCHva Holdings LLC · Gettysburg, PABuilt 1978 · S/N 290456D N500EKKar Aviation LLC · Saltville, VABuilt 1979 · S/N 1190610D N500EVSnohomish County Sheriff · Snohomish, WABuilt 1989 · S/N 0340E N500FCFerguson And Sons Construction LLC · Emmett, IDBuilt 1983 · S/N 0442E

Back to AD 2002-13-05 R1