OpenAirDocs.org
AD 2002-06-08

Registered aircraft · 131

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
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-06-08')
    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-06-08')
  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.

N59410Johnson Helicopter Service Inc · Kuna, IDBuilt 1973 · S/N 6868N5BGLinscott Jeffrey Rodman · Boring, ORBuilt 1988 · S/N S799N6032ESummit Helicopters Inc · Salem, VABuilt 1996 · S/N 5232N62409Costa James J · Goff, KSBuilt 1962 · S/N 1455N6651HR & R Conner Aviation LLC · Conner, MTBuilt 1979 · S/N 45211N66RRRiggs Rock Alan · Lake Mary, FLBuilt 1979 · S/N 45278N69FHelicopters Inc · Cahokia, ILBuilt 1996 · S/N 53025N705FSHvl Construction Inc · Fresno, CABuilt 1994 · S/N E-2836N720BGentem Inc Trustee · Wilmington, DEBuilt 1980 · S/N 45452N721KHBruce Mike · Evadale, TXFirst renewal noticeBuilt 1984 · S/N E-2214N727JSTrickett Michael W · Washington, DCBuilt 2002 · S/N 5048N749FFHunt-Lo Farms LLC · Chesterland, OHBuilt 1983 · S/N 45773N76DCAdvanced Trucking LLC · Kalispell, MTBuilt 1980 · S/N 45471N771KESchilling Michael K · Kenai, AKBuilt 2004 · S/N 51002CN772DWCcf Ventures Inc · Bangor, MEBuilt 1976 · S/N 007N775DWCosta James J · Prineville, ORBuilt 1976 · S/N 028N777EMAlaskan Wings LLC · Anchorage, AKBuilt 1983 · S/N 45767N77DCOmega 377 Pennsylvania LLC · Shavertown, PABuilt 1985 · S/N E-2289N7860SMagnum Aviation LLC · Goff, KSS/N 6627N787RCRegistered aircraftBuilt 1987 · S/N 2012N8118YSanborn Richard E Trustee · Bethlehem, NHS/N 2017N888SWSeawind Mjw LLC · Wappingers Falls, NYBuilt 2005 · S/N 60N902EHNorth Wind Aviation LLC · Chelan, WAS/N 45769N91018Two Wise Guys Aviation LLC · Le Sueur, MNBuilt 1965 · S/N 3558N965RWWilmarth Russell · Alton Bay, NHBuilt 2002 · S/N 5047N96AEAir Evac Ems Inc · O Fallon, MOBuilt 1982 · S/N 45751N970YGCbk LLC · Eagle, COBuilt 1979 · S/N P21000219N9762CFort Wolters Helicopters · Mineral Wells, TXBuilt 1962 · S/N 2159N979NFresh Air LLC · Camarillo, CABuilt 1983 · S/N 45777N981RDSunrise Adventures LLC · Stillwater, MNBuilt 1981 · S/N U20605872N9993CTemplar Helicopters LLC · Glendale, AZS/N 45682
Back to AD 2002-06-08