OpenAirDocs.org
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.

N147TXTexas Department Of Transportation · Austin, TXBuilt 1979 · S/N U20604987N1493MOverly Terrence L · Tok, AKS/N U20601493N1494CFour C'S Equipment Leasing LLC · Fresno, CABuilt 1978 · S/N 21063065N14JEN14je LLC · White Springs, FLBuilt 1975 · S/N 21060792N14LVSmetana Louis V III · Blair, NEBuilt 1970 · S/N 21059259N14NNAms Aviation LLC · South Bend, INBuilt 1980 · S/N U20605374N1503UAmerican Jet Center Inc · Chino, CABuilt 1973 · S/N U20602228N150SCAnderson Thomas R · Seattle, WABuilt 1973 · S/N U20601958N1517UN1517u LLC · Mequon, WIBuilt 1969 · S/N 20700117N1518UN1518u LLC · Waukesha, WIS/N 20700118N151MTIsland Mountain Aviation LLC · Vesta, MNBuilt 1973 · S/N 21059861N152BTCoho Aviation LLC · Hillsboro, ORBuilt 1980 · S/N P21000486N1542UWarner Walt M · Willow, AKBuilt 1973 · S/N U20602249N1545GSaltzer Eric R · Somerton, AZBuilt 1966 · S/N T210-0208N154BCTen Knot Tailwind LLC · Mesa, AZBuilt 1969 · S/N 21059157N154EFAdams Donald C · Garner, NCBuilt 1968 · S/N 21059089N155DGJuliet Tango Flying Services LLC · Walnut Creek, CABuilt 1983 · S/N 21064815N155DVDunning Vineyards · Haines, ORS/N U20602985N155RCClark 155 LLC · Missoula, MTS/N 21064312N1569USchoolcraft Carl L · West Harrison, INBuilt 1973 · S/N U20602262N1570UReno70 LLC · Anchorage, AKBuilt 1970 · S/N 20700170N1571UFavero Michael R · Sacramento, CABuilt 1973 · S/N U20602263N1574PSouthern Seaplane Inc · Belle Chasse, LABuilt 1976 · S/N 21061258N1576MSkyline Aviation Services LLC · Miramar, FLBuilt 1977 · S/N 21061948N1587UGrant Aviation Inc · Anchorage, AKS/N 20700187N1595UJoiner Aviation LLC · Vinemont, ALBuilt 1973 · S/N U20602269N15CWN15cw LLC · Wilmington, DEBuilt 1983 · S/N P21000824N15DACamborne USA LLC · Collierville, TNS/N 21061765N15MLN15ml LLC · Cresskill, NJBuilt 1977 · S/N 21061780N15MWZeezee LLC · Phoenix, AZBuilt 1978 · S/N 21063023N15TBEast West Helicopter Inc · Batesville, INBuilt 1979 · S/N 21063331N15USFlypower Inc · Fort Lauderdale, FLBuilt 1975 · S/N 21060676N1600XLd&B LLC · Show Low, AZS/N 21060636N1605MSelter Eric Jay Trustee · Agoura Hills, CABuilt 1977 · S/N 21061950N1609XHarvey P J · Midland, TXBuilt 1975 · S/N 21060645N1615XBvi Aviation LLC · Wilmington, DEBuilt 1975 · S/N 21060651N161VPConservation Aviation LLC · Washington, DCBuilt 1971 · S/N U20601719N1625UFly2k LLC · San Jose, CABuilt 1982 · S/N 21064710N162VPVirunga Airwing LLC · Washington, DCS/N U20606215N1633XRhodes Donald P · Fort Worth, TXBuilt 1975 · S/N 21060669N1634XBadwater Ranch Inc · Lysite, WYBuilt 1975 · S/N 21060670N1636XMonke Farm & Cattle Co · Nickerson, NEBuilt 1975 · S/N 21060672N163CLJust Saying Construction LLC · Merritt Island, FLS/N 21062122N164VPConservation Aviation LLC · Washington, DCS/N U20601942N1650UWilson Joshua Allen · Mckinney, TXBuilt 1974 · S/N 20700250N1651XPeters Mark E · Newport News, VABuilt 1975 · S/N 21060686N1652XBlackbridge Holdings LLC · Helena, MTBuilt 1975 · S/N 21060687N1655XApostolou Gregory · Henderson, NVBuilt 1975 · S/N 21060690N1656XAnderson George E · Newnan, GABuilt 1975 · S/N 21060691N1657XRowe William W · Provo, UTBuilt 1975 · S/N 21060692
Back to AD 2002-07-01