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.

N756WRReinbold Frederick K · Anchorage, AKBuilt 1978 · S/N U20604566N756XEKachemak Air Service LLC · Homer, AKBuilt 1978 · S/N U20604432N756XYArizona Air Salvage · Phoenix, AZBuilt 1978 · S/N U20604450N756YCMb Aviation LLC · Ridgefield, WABuilt 1978 · S/N U20604454N756YDGarza Aircraft Inc · Harlingen, TXBuilt 1978 · S/N U20604455N756YHGroundhog Mining And Milling Co LLC · Dillon, MTS/N U20604459N756YSShoreline Consulting · Bryan, TXBuilt 1978 · S/N U20604468N756ZHHeartland Aviation Inc · Alliance, NES/N U20604483N756ZVSmokey Bay Air Inc · Homer, AKBuilt 1978 · S/N U20604495N7576NHusum Charles · Redmond, WABuilt 1977 · S/N U20603683N75773Dena'Ina Leasing Agency LLC · Anchorage, AKBuilt 1980 · S/N 20700643N7584NCarto Flight Inc · Willoughby, OHBuilt 1977 · S/N U20603689N75870Westwind Aviation Inc · Phoenix, AZBuilt 1980 · S/N 20700648N758FCapital Aircraft LLC · Juneau, AKBuilt 1976 · S/N U20603629N7590NIventosch Leonard · Mccall, IDBuilt 1977 · S/N U20603694N7591NJones Michael D · Southern Pines, NCBuilt 1979 · S/N 21063240N75935Allison Aviation LLC · Missoula, MTBuilt 1975 · S/N 21060741N7594MNcneill Dudley · Happy, TXBuilt 1977 · S/N 21062025N7598ZCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1981 · S/N U20606382N7599NAir Conejos Inc · El Paso, TXBuilt 1979 · S/N 21063243N75DAHenderson John L · Ozona, TXBuilt 1979 · S/N 21063172N75DKPaul Mark A · Warren, OHS/N U20603217N75DMPro-Rentals Inc · Athens, OHBuilt 1976 · S/N 21061430N75EELgc Consulting Inc · Salisbury, NCBuilt 1975 · S/N 21060837N75GLSkyshare LLC · Boulder, COBuilt 1973 · S/N 21059814N75LGMarr Lance · Portland, ORBuilt 1978 · S/N P21000015N75PJJohnson Peter G · Tower, MNBuilt 1975 · S/N U20602705N75RCJoffe Zalman · Bahama, NCBuilt 1981 · S/N 21064325N75VRSlt Global Alliances LLC · Las Vegas, NVBuilt 1979 · S/N P21000429N75WFSjs Holdings LLC · Los Angeles, CABuilt 1980 · S/N P21000617N7600NKeller Douglas O · West Linn, ORBuilt 1977 · S/N U20603704N7605URyan Air Inc · Anchorage, AKBuilt 1978 · S/N 20700443N7610CSawtooth Flying Service Inc · Mccall, IDBuilt 1977 · S/N U20603924N7610MEickhoff Steven M · Fountain, MNBuilt 1977 · S/N 21062030N7615NHelms Aviation Inc · Long Lake, NYBuilt 1977 · S/N U20603706N761AGChalk 2 Inc · Apple Valley, CABuilt 1977 · S/N 21062097N761AKHub Properties Ltd · Wilmington, DEBuilt 1977 · S/N 21062100N761ALPacific Valley Aviation Inc · Arbuckle, CABuilt 1977 · S/N 21062101N761AMGood Enuf LLC · Wilmington, DEBuilt 1977 · S/N 21062102N761ANWinger Cattle Company Inc · Johnson, KSBuilt 1977 · S/N 21062103N761AQOrangesocks Aviation LLC · Chesterland, OHBuilt 1977 · S/N 21062105N761BDRockwell Richard E · Aledo, TXBuilt 1977 · S/N 21062118N761BEAnderson Kristian L · Albuquerque, NMBuilt 1981 · S/N P21000660N761BLLong Ernest D · Trabuco Canyon, CABuilt 1977 · S/N 21062125N761BVN761bv LLC · Sioux Falls, SDBuilt 1977 · S/N 21062134N761BYB&E Leasing LLC · Dubuque, IABuilt 1977 · S/N 21062137N761BZAltair Aircraft LLC · Gainesville, FLBuilt 1977 · S/N 21062138N761CECharlie Echo Enterprises LLC · Cedar Hills, UTBuilt 1977 · S/N 21062143N761CLUlrick Michael R · Spokane, WABuilt 1977 · S/N 21062149N761CNFrance Sherrod W Trustee · Rawlins, WYBuilt 1977 · S/N 21062151
Back to AD 2002-07-01