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.

N7389UYr-Aircraft Leasing LLC · Bethel, AKBuilt 1978 · S/N 20700432N7391PShph LLC · Edwards, ILBuilt 1978 · S/N P21000011N7392USpernak Airways Inc · Anchorage, AKFirst renewal noticeBuilt 1978 · S/N 20700435N7396UAlaska Aircraft Leasing LLC · Silverdale, WABuilt 1978 · S/N 20700438N739MCaurus Power Inc · Santa Rosa, CABuilt 1978 · S/N P21000063N73CYRti Fabrication Inc · Plains, MTS/N U20606815N73LLT3 Aviation LLC · Oak Point, TXBuilt 1977 · S/N 21062163N73RBTurbo Centurion LLC · North Salt Lake, UTS/N 21061758N740United States Department Of Interior · Boise, IDBuilt 1980 · S/N U20605724N7402QRichs Alaskan Flying Adventures LLC · Wasilla, AKBuilt 1973 · S/N U20602192N74206Chinn Larry · Anatone, WABuilt 1974 · S/N U20602457N7433NFixed Gear LLC · Sherwood, ARBuilt 1977 · S/N U20603660N7448NCcx-2000-0111 LLC · Garberville, CABuilt 1977 · S/N U20603662N744RCastaneda Jose · Yakima, WABuilt 1974 · S/N 21060521N745KPPaklook Air Inc Dbi · Bethel, AKFirst renewal noticeBuilt 1974 · S/N 20700238N746KPFox Aircraft LLC · Wasilla, AKBuilt 1983 · S/N 20700766N746ZXSlater R Winston Trustee · St Charles, ILS/N 21064368N7476QSmith Keith S · Fredericksburg, TXBuilt 1973 · S/N U20602216N747SQYr-Aircraft Leasing LLC · Bethel, AKBuilt 1977 · S/N 20700387N7485QEvans Charles H Trustee · Hooksett, NHBuilt 1973 · S/N U20602220N7487Q206 LLC · Anchorage, AKBuilt 1973 · S/N U20602221N748KPKalinin Partners LLC · Juneau, AKBuilt 1976 · S/N U20603279N749KPKalinin Partners LLC · Juneau, AKBuilt 1980 · S/N U20605554N749RVTime Machine LLC · Kailua Kona, HIS/N U20603480N749SPNew York State Police · Latham, NYBuilt 1986 · S/N U20606957N74ESValiair Ltd Co Trustee · Casper, WYBuilt 1979 · S/N P21000279N74LCLee County Sheriffs Office · Ft Myers, FLBuilt 1972 · S/N 21059755N74MMFief Ron C · Creede, COBuilt 1974 · S/N 21060375N74PSOrion Works Inc · Denali Park, AKBuilt 1973 · S/N U20601894N74RMGrimes Taylor · Odessa, TXBuilt 1976 · S/N 21061694N750NTEle Motorsports LLC · Dover, DEBuilt 1978 · S/N U20604230N7532NEagle Air LLC · Morgantown, WVBuilt 1977 · S/N U20603664N7539NDavis Dale L · Boerne, TXBuilt 1977 · S/N U20603666N7551ZKustatan Leasing LLC · Kenai, AKS/N U20606365N7559KSkyway II LLC · Naples, FLS/N P21000410N755CMCluster Fish LLC · Charleston, SCBuilt 1980 · S/N 21063934N755SWMelendez Daniel Alexan · Yuma, AZBuilt 1975 · S/N 21060965N7561NPierce County Sheriffs Department · South Hill, WABuilt 1977 · S/N U20603673N7567KCutler Jeffrey R · Columbus, INBuilt 1979 · S/N P21000411N7567QJolley Joseph J · Anchorage, AKBuilt 1978 · S/N U20604275N7568270 North LLC · Anchorage, AKBuilt 1980 · S/N 20700638N7568MPeters William R · Naperville, ILBuilt 1977 · S/N 21062021N7569NArctic Aviation Leasing LLC · Anchorage, AKBuilt 1977 · S/N U20603679N756AHKincaid Linda C · North Pole, AKBuilt 1977 · S/N U20603932N756ANJelinek Tyson · Iola, KSBuilt 1977 · S/N U20603937N756AVSmith Air LLC · Cascade, IDBuilt 1977 · S/N U20603944N756BBCampbell Steven P · Annapolis, CABuilt 1977 · S/N U20603950N756BNBeck Skydiving & Rigging LLC · Bixby, OKBuilt 1977 · S/N U20603961N756BYW Yerxa LLC · Colusa, CAS/N U20603971N756CLEgli Sam · King Salmon, AKBuilt 1977 · S/N U20603983
Back to AD 2002-07-01