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.

N8706ZElliott Michael L · Raeford, NCBuilt 1968 · S/N P206-0506N8710QMicro Tool Inc · Idaho Falls, IDFirst renewal noticeBuilt 1980 · S/N U20605641N8711ZNeff John Sr · Lumberton, TXBuilt 1968 · S/N P206-0511N8715ZMarconi Joseph · Hamilton, OHBuilt 1968 · S/N P206-0515N8719ZFedane Rohit · Green Bay, WIBuilt 1968 · S/N P206-0519N8725QN8725q LLC · Grand Junction, COBuilt 1976 · S/N U20603478N8725ZRomine George · Tucson, AZBuilt 1968 · S/N P206-0525N8727ZRobertson Reuben · Johnson City, TNBuilt 1968 · S/N P206-0527N8731QHinlein Erich S · Pelham, MABuilt 1976 · S/N U20603484N8732ZZiprik Russell L · Ball Ground, GABuilt 1968 · S/N P206-0532N8733ZTerway William · Wilsonville, ORBuilt 1968 · S/N P206-0533N8734ZHardin Matthew W · Rutherford, CABuilt 1968 · S/N P206-0534N8735ZMcgarity Justin D · Paragould, ARBuilt 1968 · S/N P206-0535N8736QCourtney Aviation LLC · Columbia, CABuilt 1976 · S/N U20603489N8740QHampton Harvey E · Simms, MTS/N U20603493N8753ZBloated Armadillo Adventures Corp · Wilmington, DES/N P206-0553N8754QD2 Holdings LLC · Salt Lake City, UTBuilt 1976 · S/N U20603507N8754ZBwana Z Transporation LLC · Missoula, MTBuilt 1968 · S/N P206-0554N8755QMartensen Marten · Anchorage, AKBuilt 1976 · S/N U20603508N8756QTriple 2 LLC · Burlington, COBuilt 1976 · S/N U20603509N8758QBerge Christian · Mccall, IDBuilt 1976 · S/N U20603511N8758ZBellows Paul F · Vancouver, WABuilt 1968 · S/N P206-0558N8759ZHelin Bruce A Trustee · Flagstaff, AZBuilt 1968 · S/N P206-0559N8761ZHaag Walter G · Fall City, WABuilt 1968 · S/N P206-0561N8763QArtic Backcountry Flying Service LLC · Kotzebue, AKBuilt 1976 · S/N U20603516N8763ZMacdonald John R · Vancouver, WABuilt 1968 · S/N P206-0563N876R76r Holdings LLC · Rockport, TXBuilt 1978 · S/N 21062844N8773ZPolhamus Mark Trustee · Thompson Falls, MTBuilt 1969 · S/N P206-0573N8774ZAero Squadron LLC · San Diego, CABuilt 1969 · S/N P206-0574N8775ZB&B Auto Body LLC · Terreton, IDS/N P206-0575N8781ZHogue Marc · Tempe, AZBuilt 1969 · S/N P206-0581N8783ZAdventure Aircraft And Equipment LLC · Chelan, WABuilt 1969 · S/N P206-0583N8787Q2fly Safety LLC Trustee · Azle, TXBuilt 1976 · S/N U20603539N8787ZKing Farm Partnership · Mccrory, ARBuilt 1969 · S/N P206-0587N8788QKochert Timothy B · Anchorage, AKBuilt 1975 · S/N U20602730N8789ZParrott Charles F · Saugus, MAFirst renewal noticeBuilt 1969 · S/N P206-0589N8792ZPerkovich Brian T · Oneida, WIBuilt 1969 · S/N P206-0592N8794ZJones Petroleum Co Inc · Jackson, GAS/N P206-0594N8795QWright Air Service Inc · Fairbanks, AKBuilt 1976 · S/N U20603547N8795ZNeuschaefer George H · White Hills, AZBuilt 1969 · S/N P206-0595N8796QSpangler Robert E · Anchorage, AKBuilt 1976 · S/N U20603548N8797ZCjc Enterprises LLC · Erda, UTBuilt 1969 · S/N P206-0597N8799ZMagnuson Robert L Jr · Mc Grath, AKBuilt 1969 · S/N P206-0599N87MUUrdaneta Luis · Miramar, FLS/N U20605271N87RWSunward Corp · Denver, COBuilt 1967 · S/N U206-0943N8823HBowers Phillip P · Clayton, NCBuilt 1970 · S/N 21059314N8844GNorthside Logistics And Automotive Inc · Dardanelle, ARS/N 21059144N886KHLexi Air LLC · Boise, IDBuilt 1977 · S/N 21061727N887PBZankiz Jose Carlos · Naples, FLBuilt 1968 · S/N U206-1062N887WQuad City Area Flying Eagles Inc · Milan, ILBuilt 1975 · S/N 21060976
Back to AD 2002-07-01