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.

N5318ABuchanan Harvey · Townsend, MABuilt 1979 · S/N 21063366N5318VTyson Ron A · Fredericksburg, TXBuilt 1975 · S/N 21060906N531ECBlue Jets LLC · Rialto, CABuilt 1981 · S/N P21000725N5323URio Farms LLC · King City, CABuilt 1984 · S/N 21064865N5325YBeehive Telephone Co Inc Nevada · Lake Point, UTBuilt 1980 · S/N 21064164N532CHWhedbee Donald Justin · Conroe, TXBuilt 1980 · S/N P21000501N532DGRio Farms LLC · King City, CABuilt 1983 · S/N P21000829N5336YBlue Sky Inc · Lone Rock, IAS/N 21064170N5337YClement Aviation Inc · Tea, SDBuilt 1980 · S/N 21064171N5338AThompson Richard T · Wilmington, OHBuilt 1979 · S/N 21063376N5338UWatermelon Packer Ll · Mcallen, TXBuilt 1984 · S/N 21064871N533KAKamaka Air LLC · Honolulu, HIBuilt 1973 · S/N 20700216N5340WHebel Ryan · North Potomac, MDBuilt 1981 · S/N P21000675N5340YCripe Michael L · San Luis Obispo, CABuilt 1980 · S/N 21064173N5348UC3 Shadow LLC · Columbus, OHBuilt 1984 · S/N 21064874N5348YWheeler Robert T · Silt, COBuilt 1980 · S/N 21064176N5358UMadson Chris · King City, CABuilt 1984 · S/N 21064877N5359APalo Duro Aircraft Services Lc · Mckinney, TXBuilt 1979 · S/N 21063388N535AKWilson Thomas Henry III · Anchorage, AKS/N U20604357N535MESky West Aviation Inc Trustee · Albuquerque, NMBuilt 1979 · S/N P21000345N5362AFerguson Lynn D · Alpine, WYBuilt 1979 · S/N 21063391N5363ULefore Jeffry Thomas · Milton Freewater, ORS/N U20605244N5368AValiair Limited Co Trustee · Casper, WYBuilt 1979 · S/N 21063394N5368UBornwasser Louis W · Prospect, KYBuilt 1984 · S/N 21064880N5369AMartens Charles H · Nokomis, FLBuilt 1979 · S/N 21063395N5369YPollard William Edward · Big Spring, TXBuilt 1980 · S/N 21064185N536WCN8qb LLC · Thief River Falls, MNBuilt 1972 · S/N 21059794N5370UPogany Steve C · Anchorage, AKBuilt 1979 · S/N U20605251N5371XMarks Max · Cape Elizabeth, MES/N U20605687N5378PBlue Skies Today LLC · Eagan, MNBuilt 1974 · S/N U20602492N5379ABrechtelsbauer Paul · Farmville, NCBuilt 1979 · S/N 21063403N5383ASummers Timothy P · Rincon, GABuilt 1979 · S/N 21063405N5386ATriplett And Adams Transport Partnership LLC · New Concord, OHBuilt 1979 · S/N 21063406N5388YValiair Lc Trustee · Casper, WYBuilt 1980 · S/N 21064190N5391ASingh Amandeep · Stockton, CABuilt 1979 · S/N 21063408N5394XL K Hollenbeak Logging Inc · Hayfork, CABuilt 1980 · S/N U20605710N5395VCortez Flying Service Inc · Cortez, COBuilt 1975 · S/N 21060930N53SGJecker Scott W · San Marcos, TXS/N 21062609N53TMSmith Douglas M · Hackettstown, NJBuilt 1975 · S/N 21060762N5400VWilson Darryl M · Granger, INFirst renewal noticeS/N 21060935N5401AHeadon Richard · Chino Hills, CABuilt 1979 · S/N 21063414N5401XBarbera Frank M · Edgewood, NMBuilt 1980 · S/N U20605717N5404WBas Part Sales LLC · Greeley, COBuilt 1981 · S/N P21000683N5409YLee Christopher · Katy, TXBuilt 1980 · S/N 21064198N5411AMarc Aircraft Holding LLC · Soldotna, AKBuilt 1979 · S/N 21063422N5411XUsda Aphis Ppq · Edinburg, TXBuilt 1980 · S/N U20605727N5416UU S Department Of Agriculture · College Station, TXBuilt 1984 · S/N 21064890N5416YKer Holdings LLC · Henderson, NVBuilt 1980 · S/N 21064199N5417YFeldner Mark A · Schererville, INBuilt 1980 · S/N 21064200N5424AFudurich David E · Goleta, CABuilt 1979 · S/N 21063428
Back to AD 2002-07-01