AD 2002-01-10

Registered aircraft · 816

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-01-10')
    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-01-10')
  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.

N64CDynamic Avlease Inc · Bridgewater, VAFirst renewal noticeBuilt 1967 · S/N LM-32N64KAXin Han Aviation LLC · Helena, MTBuilt 1973 · S/N LJ-606N655DFBlue Earth Flying Service LLC · Blue Earth, MNBuilt 1989 · S/N LJ-1197N6563KBeech Transportation Inc · Eden Prairie, MNBuilt 1982 · S/N LJ-1032N65MSSummey Aviation LLC · Asheville, NCS/N LW-202N65TADodson International Parts Inc · Rantoul, KSBuilt 1971 · S/N LJ-538N65UDynamic Avlease Inc · Bridgewater, VAFirst renewal noticeBuilt 1967 · S/N LM-87N65VDynamic Avlease Inc · Bridgewater, VAFirst renewal noticeBuilt 1968 · S/N LM-113N662JSHughes Leasing Co · Miami, FLBuilt 1976 · S/N LW-176N665JKSprinklermatic Florida LLC · Davie, FLBuilt 1975 · S/N LJ665N6681SN6681s LLC · Helena, MTBuilt 1979 · S/N LJ-850N6692DWisodak Air LLC · Eau Claire, WIBuilt 1984 · S/N LJ-1072N66ADRed Light Skydiving LLC · Jackson, MIBuilt 1968 · S/N LJ-380N66GSMile Hi Skydivers Inc · Longmont, COS/N LJ-237N66KAMullins Michael · Seaford, DES/N LJ-582N66WDynamic Avlease Inc · Bridgewater, VAFirst renewal noticeBuilt 1967 · S/N LM-68N671LLCentral Virginia Aviation Inc · North Dinwiddie, VABuilt 1966 · S/N LJ-148N6723YKair Air LLC · Marietta, GABuilt 1982 · S/N LJ-1013N6754HAviation Communication And Surveillance Systems · Phoenix, AZBuilt 1980 · S/N LJ-891N6763KAla Ark LLC · Germantown, TNBuilt 1984 · S/N LJ-1064N677JHobbs Aircraft LLC · Waco, TXBuilt 1978 · S/N LW-294N67BDynamic Avlease Inc · Bridgewater, VABuilt 1967 · S/N LM-59N67CQBeech Baron LLC · Wilmington, NCBuilt 2000 · S/N LJ-1619N67KDynamic Avlease Inc · Bridgewater, VAFirst renewal noticeBuilt 1967 · S/N LM-24N67VSouthall Properties LLC · Vicksburg, MSBuilt 1978 · S/N LW-306N681CAJet Air Inc · Galesburg, ILBuilt 1995 · S/N LJ-1414N681EVQb Corp · Salmon, IDBuilt 1990 · S/N LJ-1228N681SDJefferson County Sheriffs Office · Beaumont, TXBuilt 1993 · S/N LJ-1342N682KALott Dalton Leon · Duncanville, TXS/N LJ-682N683MG1976 King LLC · Scottsdale, AZBuilt 1976 · S/N LJ-683N687MMBuckeye Fluids LLC · Wilmington, DEBuilt 2002 · S/N LJ-1667N68CDSkydive Myrtle Beach Inc · Southport, NCBuilt 1968 · S/N LJ-366N690GLathem Russell Glen · Dalhart, TXBuilt 1972 · S/N LW-34N690KABank Of Utah Trustee · Salt Lake City, UTBuilt 1984 · S/N LJ1101N692WGuardian Flight LLC · Lewisville, TXBuilt 2003 · S/N LJ-1692N699CCC & C Market Research Inc · Fort Smith, ARBuilt 1999 · S/N LJ-1553N6KZDodson International Parts Inc · Rantoul, KSBuilt 1966 · S/N LJ-238N7000BBeechcraft Heritage Museum Inc · Tullahoma, TNS/N LM-01N7007GDynamic Aviation Group Inc · Bridgewater, VAFirst renewal noticeS/N LM-02N70088School Of Missionary Aviation Technology · Ionia, MIS/N LM-06N700DHGramer Air II LLC · Bloomfield Hills, MIBuilt 1974 · S/N LW-114N700WWAces Full Inc · Deadwood, SDBuilt 1985 · S/N LJ-653N7010LDynamic Aviation Group Inc · Bridgewater, VAFirst renewal noticeS/N LM-07N7014LDynamic Aviation Group Inc · Bridgewater, VAFirst renewal noticeS/N LM-10N7018FDynamic Aviation Group Inc · Bridgewater, VAS/N LM-13N701NCNorth Country Aviation Inc · Gaylord, MIBuilt 1972 · S/N LW-18N701XPFlight Partners 2 LLC · Lincoln, NEBuilt 1979 · S/N LJ-826N70292Dynamic Aviation Group Inc · Bridgewater, VAFirst renewal noticeS/N LM-18N70356Dynamic Aviation Group Inc · Bridgewater, VAFirst renewal noticeS/N LM-25N7036LDynamic Aviation Group Inc · Bridgewater, VAFirst renewal noticeS/N LM-26
Back to AD 2002-01-10