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.

N51SARedtail Partners LLC · Moab, UTBuilt 1981 · S/N 20700699N5200QBas Part Sales LLC · Greeley, COBuilt 1969 · S/N 21059130N5200XRwr Air Inc · Tok, AKBuilt 1980 · S/N U20605591N5201ADan Howard Aircraft Sales LLC · Tulsa, OKBuilt 1979 · S/N 21063305N5203AGv Air Inc · Medford, ORBuilt 1979 · S/N 21063306N5203XMike & Critter LLC · Mccall, IDBuilt 1980 · S/N U20605592N5209COlson Alan G · New London, MNBuilt 1979 · S/N 21063716N5217CHydro Wings Inc · Valle Crucis, NCBuilt 1979 · S/N 21063719N5217VScrobola Air LLC · Wyoming, PABuilt 1975 · S/N 21060863N521BWBilmar Avionics Inc · Kissimmee, FLBuilt 1974 · S/N 21060297N521KMMcmorries Kyle P · Nacogdoches, TXBuilt 1984 · S/N 21064868N521SCHarrison Ted W · Grapevine, TXBuilt 1977 · S/N 21062343N5223AGeneral Plumbing Inc · Walnut Creek, CABuilt 1979 · S/N 21063316N5225VKuhn Chad · Boulder, WYBuilt 1975 · S/N 21060867N5228VDynamite Marketing Inc · Meridian, IDBuilt 1975 · S/N 21060870N522GHQuailridge Aviation LLC · Clarkston, WABuilt 1979 · S/N 21063399N523RCS W Air Travel Inc · Parshall, COBuilt 1975 · S/N 21060654N5244ZRobinson Levi B · Anchorage, AKBuilt 1981 · S/N U20606085N524MMAviation Trust Company LLC Trustee · Oklahoma City, OKBuilt 1979 · S/N 21063717N5252ALong Harold M · Carson City, NVBuilt 1979 · S/N 21063327N5255ABishop Michael J · Lima, OHBuilt 1979 · S/N 21063329N525KWFuller Thomas R · Scottsdale, AZBuilt 1975 · S/N 21060881N5260AN5260a LLC · Los Angeles, CAS/N 21063333N5263VMccullough James M · Monte Vista, COBuilt 1975 · S/N 21060883N5264CCullum Transportation LLC · North Charleston, SCBuilt 1979 · S/N 21063725N5267VN5267v LLC · Northbrook, ILBuilt 1975 · S/N 21060886N526CHSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1981 · S/N P21000662N5274YMba Sales LLC · Ridgefield, WABuilt 1980 · S/N 21064147N5275VViatrans LLC · Pryor, OKBuilt 1975 · S/N 21060890N5276AOstermeier Brigitte · MaunNon-citizen corporation, flight hours not reportedBuilt 1979 · S/N 21063341N5276VSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1975 · S/N 21060891N5277JYr-Aircraft Leasing LLC · Bethel, AKBuilt 1984 · S/N 20700772N5277PBennett Glenn D · Kingwood, TXBuilt 1977 · S/N 21061784N5277VLechner Gary D · Woodstock, ILBuilt 1975 · S/N 21060892N5281VOne Vector LLC · Wolcott, COBuilt 1975 · S/N 21060896N5287ATax Busters Inc · El Paso, TXBuilt 1979 · S/N 21063349N5287YMorrow Aviation LLC · Midland, TXS/N 21064152N528WARiley David P · South Barrington, ILBuilt 1979 · S/N P21000315N5293XBaker Leasing LLC · Kotzebue, AKS/N U20605612N529ADDcm Air LLC · Canton, MIBuilt 1980 · S/N P21000603N52MMHappy Sky LLC · Brooklyn, NYS/N 21064870N52SEPryor Jeff · Santa Barbara, CABuilt 1978 · S/N P21000080N5300ARunzel Brothers Aviation LLC · Bensenville, ILBuilt 1979 · S/N 21063356N5302VSniader David J · Miami, FLFirst renewal noticeBuilt 1975 · S/N 21060902N5303XRedemption Inc · Kodiak, AKBuilt 1980 · S/N U20605622N5313USky Quest 210 LLC · Clarksdale, MSBuilt 1984 · S/N 21064862N5314VBurke Sterling M · Olympia Fields, ILBuilt 1975 · S/N 21060905N5314XMoody Bible Institute Of Chicago · Spokane, WAS/N U20605633N5315XAtarah LLC · Tucson, AZBuilt 1980 · S/N U20605634N5317ABlue Skies Air LLC · Allen, TXBuilt 1979 · S/N 21063365
Back to AD 2002-07-01