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.

N72306Usda Aphis Ppq · Edinburg, TXBuilt 1969 · S/N U206-1360N72309Orion Works Ltd · Denali Park, AKBuilt 1969 · S/N U206-1362N72313Alaskan Air Charter LLC · Anchorage, AKBuilt 1969 · S/N U206-1365N72337Gilbert Daniel Keith · Kodiak, AKBuilt 1969 · S/N U206-1374N72347Hone Landscape Company LLC · Carnation, WABuilt 1969 · S/N U206-1377N72395Orion Works Ltd · Denali Park, AKBuilt 1969 · S/N U206-1393N723FClear Skies LLC · Stuart, FLBuilt 1983 · S/N U20606714N72412Intricate Bay Operating LLC · Saylorsburg, PABuilt 1969 · S/N U206-1396N7247NMartin Christian E · Amagansett, NYBuilt 1976 · S/N U20603582N7250NSimon Jevon · Buckley, WABuilt 1979 · S/N 21063213N7257NPeterson Winston Roy II · Arbuckle, CABuilt 1976 · S/N U20603588N7267NSwalling John C · Anchorage, AKBuilt 1976 · S/N U20603594N7269NAk Air Leasing LLC · Homer, AKBuilt 1976 · S/N U20603595N726HSSpmhrt 206 LLC · East Bernard, TXS/N U20606947N7276NDancer Aviation LLC · Delphos, OHBuilt 1976 · S/N U20603597N727FValiair Ltd Co Trustee · Casper, WYBuilt 1981 · S/N P21000727N727FACorporate Services LLC · Baton Rouge, LAS/N 21059414N727FKVan Schoonhoven Peter · Battle Ground, WABuilt 1967 · S/N 21058912N727NEDeeair Ltd · Dayton, OHBuilt 1979 · S/N U20605152N727WSRobey Sean C · Camden, NCFirst renewal noticeBuilt 1978 · S/N 21063140N728United States Department Of Interior · Boise, IDBuilt 1985 · S/N U20606877N72VVBank Of Utah Trustee · Salt Lake City, UTBuilt 1979 · S/N P21000339N73036Johnson Deborah K · Fairbanks, AKBuilt 1979 · S/N 20700555N7303NJordan James D · Paradise, TXBuilt 1979 · S/N 21063218N73047Spernak Airways Inc · Anchorage, AKFirst renewal noticeBuilt 1979 · S/N 20700556N7304NCoastal Aviation Export LLC · Wilmington, DEBuilt 1976 · S/N U20603607N7305URyan Air Inc · Anchorage, AKBuilt 1977 · S/N 20700392N73067Grant Aviation Inc · Anchorage, AKBuilt 1979 · S/N 20700558N73100Alaska Air Taxi LLC · Anchorage, AKBuilt 1979 · S/N 20700559N73123Lake Clark Air Inc · Port Alsworth, AKBuilt 1979 · S/N 20700561N731BJArmis Strategies LLC · Hartwell, GABuilt 1979 · S/N P21000437N731CBAnesthesia Aviation LLC · Leesburg, VAS/N P21000545N731CYSan Diego Air Service · San Diego, CABuilt 1979 · S/N P21000442N731DSYou And Me LLC · Sedalia, MOBuilt 1979 · S/N P21000446N731FEJones Marilyn W · Collinsville, CTBuilt 1979 · S/N P21000450N731FKQualitair LLC Trustee · MichelstadtBuilt 1979 · S/N P21000452N731FTMillican Clifford A · Burleson, TXBuilt 1979 · S/N P21000454N731GCLavalley Asset Management Inc · Potsdam, NYBuilt 1979 · S/N P21000457N731HRBrennan Timothy · San Francisco, CABuilt 1980 · S/N P21000464N731HTAeolus Aviation LLC · Franklin, TNBuilt 1980 · S/N P21000465N731HWOne Hotel Whskey LLC · Hugoton, KSBuilt 1980 · S/N P21000468N731HYM&S Equipment Leasing LLC · Dalhart, TXS/N P21000470N731JGGate Air LLC · Ketchum, IDBuilt 1980 · S/N P21000474N731JXKai Herbert DBA · Rillito, AZFirst renewal noticeS/N P21000479N731KLMullen James P Jr · Rogers, ARS/N P21000483N731KMMartin Rick H · Las Vegas, NVS/N P21000484N731LNEastern Washington Ambulatory Anesthesia Svcs Pllc · Walla Walla, WABuilt 1980 · S/N P21000488N731LTDodson International Parts Inc · Rantoul, KSBuilt 1979 · S/N P21000436N731LUDiversified Air LLC · Kalispell, MTBuilt 1980 · S/N P21000490N731MJLake Chelan Helicopters LLC · Manson, WABuilt 1974 · S/N U20602362
Back to AD 2002-07-01