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.

N8274QBravo Delta II LLC · Steamboat Springs, COBuilt 1976 · S/N U20603135N8275MValiair Limited Company Trustee · Casper, WYBuilt 1970 · S/N 21059275N8275QAbel Derek R · Rio Vista, CABuilt 1976 · S/N U20603136N8277MBlalock Paul T · Longview, TXBuilt 1970 · S/N 21059277N827DGAfrica Inland Mission International Inc · Peachtree City, GABuilt 1981 · S/N U206-06286N827RPJireh Aviation LLC · Zeeland, MIBuilt 1980 · S/N P21000541N827TWGardner Thomas W · Lincoln, MEBuilt 1973 · S/N 21059836N8281Q9 North LLC · Parker, COBuilt 1976 · S/N U20603142N8281ZSpearfish Aviation Inc · Summerset, SDS/N U20604116N8286M3 Jc LLC · Phoenix, AZBuilt 1970 · S/N 21059286N8287MProfessional Metal Services Inc · Albion, NEBuilt 1970 · S/N 21059287N8287QAdventist World Aviation · Wilson, NCBuilt 1976 · S/N U20603148N8288MAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1970 · S/N 21059288N828RJNielsen Ron E · Lindon, UTS/N 21063836N8292MAircraft Guaranty Corp Trustee · Oklahoma City, OKS/N 21059292N8293QBaker Marianne J · Raeford, NCBuilt 1976 · S/N U20603154N829BAAdaptive Resources Inc · Fort Morgan, COBuilt 1983 · S/N P21000819N82LWMuskox Ministries · Fairbanks, AKBuilt 1973 · S/N U20602054N8300QSafeco Leasing LLC · Port Alsworth, AKBuilt 1976 · S/N U20603161N831PRThomas Bruce A · Mount Juliet, TNS/N U20603452N8334QVolatile Aero Ventures LLC · Boulder City, NVS/N U20603195N833RTNash LLC · Carbondale, ILBuilt 1982 · S/N P21000809N8340QFly8ma LLC · Big Lake, AKS/N U20603201N8345QKatahdin Air Service Inc · Hermon, MEBuilt 1976 · S/N U20603206N8352QUnited Indian Missions DBA · Tucson, AZBuilt 1976 · S/N U20603213N8355QDelta Pacific Northwest LLC · Anchorage, AKS/N U20603216N8366QBesse Richard L · Wasilla, AKFirst renewal noticeBuilt 1976 · S/N U20603227N8368QBrown Christopher · Grass Valley, CABuilt 1976 · S/N U20603229N8370QState Of Alaska Dept Of Fish And Game · Palmer, AKBuilt 1976 · S/N U20603231N8374Q8374q LLC · Gig Harbor, WABuilt 1976 · S/N U20603235N8378QAeroworks Of Alaska LLC · Chugiak, AKBuilt 1976 · S/N U20603239N8386M213tz LLC · Hailey, IDBuilt 1978 · S/N U20604520N8386QLe Tourneau University · Longview, TXBuilt 1976 · S/N U20603247N8394QPacific Union College · Angwin, CABuilt 1976 · S/N U20603255N8397QSeattle Seaplanes LLC · Seattle, WABuilt 1976 · S/N U20603258N839HFFour Boys Flying LLC · Kalispell, MTBuilt 1980 · S/N P21000633N83BMShelton David B · Dallas, TXBuilt 1983 · S/N 21064799N83CEElsner Kelly J · Menahga, MNBuilt 1980 · S/N P21000578N8405QVan Pelt Matthew · Challis, IDBuilt 1976 · S/N U20603265N8409QFrey David G Jr · Grand Rapids, MIBuilt 1976 · S/N U20603269N841JLMarks Stephen M · Monument, COBuilt 1967 · S/N T210-0330N841RQMueller Steven L · Osceola, WIBuilt 1976 · S/N U20603273N8424WExtra Equipment Inc · Stuart, FLBuilt 1979 · S/N 21063732N8439GSmith Air LLC · Cascade, IDS/N U20603790N843YTTrue Drilling LLC · Casper, WYBuilt 1979 · S/N 21063334N8442QFerguson John W · Edwardsburg, MIBuilt 1976 · S/N U20603301N8451QRunway Three Aviation LLC · Kalispell, MTBuilt 1976 · S/N U20603309N8462QPahrump Aviation LLC · Las Vegas, NVS/N U20603320N8463QSmith James M · Star, IDBuilt 1976 · S/N U20603321N8471QIgiugig Lodge LLC · Wasilla, AKBuilt 1976 · S/N U20603329
Back to AD 2002-07-01