AD 2002-07-01

Registered aircraft · 3,466

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-07-01')
    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-07-01')
  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.

N235WHTail Aero Corp · Wilmington, DEBuilt 1977 · S/N 21061797N236PTmg Investment Properties LLC · Surprise, AZS/N P21000116N2375SLundin Lawrence D · Midvale, IDBuilt 1976 · S/N 21061257N2384SChervenak A Douglas · Smyrna, DEBuilt 1976 · S/N 21061263N2390SPowerhawk Flyers LLC · Farmington Hills, MIBuilt 1976 · S/N 21061266N23CFYr-Aircraft Leasing LLC · Bethel, AKBuilt 1974 · S/N 20700276N23HBHotel Bravo Aviation LLC · Houston, TXFirst renewal noticeBuilt 1977 · S/N 21062050N23SFTarhanick Timothy P · Livonia, MIBuilt 1971 · S/N 21059547N24012Grubba Gregory T · Anchorage, AKBuilt 1974 · S/N U206-02237N2423SAircraft Sales LLC · Caledonia, MIBuilt 1976 · S/N 21061275N2425SPark Sung S · Marana, AZBuilt 1976 · S/N 21061276N242RYCity Management Corp · Sunriver, ORBuilt 1978 · S/N P21000036N2437UPlanetosea LLC · Doylestown, PABuilt 1983 · S/N 21064782N2441SSzpara John V Trustee · Chesnee, SCBuilt 1976 · S/N 21061284N244HEDubin David A · Tucson, AZS/N 21058990N2453SFilipponi-Thompson Drilling Inc · Atascadero, CABuilt 1976 · S/N 21061294N2457UBurr Ronald E · Anchorage, AKBuilt 1974 · S/N U20602378N246CCAlaska Department Of Public Safety · Anchorage, AKBuilt 1979 · S/N U20605314N246ECKnight Air LLC · Wausau, WIS/N 21062435N246JJlr Resources LLC · Naples, FLBuilt 1979 · S/N P21000355N246VTAkwe River Flying And Guide Service LLC · Yakutat, AKBuilt 1975 · S/N U20602822N247CBDream Machine Leasing LLC · Glenbrook, NVBuilt 1981 · S/N U20606194N247KMNorthern Lights Ventures LLC · Moose Pass, AKBuilt 1975 · S/N U20602872N2480SAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1976 · S/N 21061299N2481UWilliams Jeremy · Searsport, MES/N U20602380N248HSLitchfield Lantz · Las Vegas, NVBuilt 1978 · S/N 21062726N2492SSierra Hotel Aircraft LLC · Wilmington, DEBuilt 1976 · S/N 21061302N2498SKatz Michael R Trustee · Merritt Island, FLBuilt 1976 · S/N 21061306N249SPSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1975 · S/N 21060990N24CHDagostini Robert A · Mount Aukum, CABuilt 1975 · S/N 21060793N24HSSandoval Ernest D · Cave Creek, AZBuilt 1978 · S/N 21062755N24NHBeyer Roger · Paw Paw, MIBuilt 1981 · S/N 21064545N24SCGriffin Samuel C · Doniphan, MOBuilt 1977 · S/N U20603868N24TBDalks Leasing Inc · Wilmington, DEBuilt 1982 · S/N P21000799N24WWPark Avenue Group Inc · Stuart, FLBuilt 1975 · S/N 21060884N2501SGonzales Gerald · Dallas, TXS/N 21061307N2506SByers Roger G · Lake Elmo, MNS/N 21061309N2508SErnst Don A · San Luis Obispo, CABuilt 1976 · S/N 21061311N2525XTolbert Mark A · Canandaigua, NYBuilt 1977 · S/N 21061803N252SWSymns Robert A · Aguila, AZBuilt 1978 · S/N 21063029N2538SBarbo Walter A · Aurora, COBuilt 1976 · S/N 21061322N254SWalker Curtis · Lake Havasu, AZS/N 21061198N254TSGiesbrecht Nolan R · Burns, ORBuilt 1974 · S/N U20602381N2550SGrewal Amritpal S · Stockton, CAS/N 21061326N2563SClements Kenneth Brian · Las Vegas, NVBuilt 1976 · S/N 21061330N256TETimberline Excuvation Inc · Fairbanks, AKBuilt 1969 · S/N U2061336N2572SGwin Bryan · La Porte, TXBuilt 1976 · S/N 21061332N2573QJayviation Inc · Lake City, FLBuilt 1969 · S/N 21059173N257SPAviatzone LLC · Fort Lauderdale, FLBuilt 1977 · S/N 20700781N2580SArizona Production Machinery & Supply · Casa Grande, AZBuilt 1976 · S/N 21061333
Back to AD 2002-07-01