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.

N575CLilly David E · Allentown, PABuilt 1971 · S/N LJ-532N579PSFoxtrot Charlie Inc · Grass Valley, CABuilt 1970 · S/N LJ-496N57AGMonument Aviation LLC · North Chesterfield, VABuilt 1968 · S/N LJ-343N580RAGibson & Harrup Leasing LLC · North Dinwiddie, VABuilt 1973 · S/N LJ-580N585ATJr & M Air LLC · San Antonio, TXBuilt 1989 · S/N LJ-1203N586YDDodson International Parts Inc · Rantoul, KSS/N LJ1696N588SAReach Air Medical Services LLC · Santa Rosa, CABuilt 2000 · S/N LJ-1588N588SDIal Corp · Lewes, DES/N LJ-1663N590SHAlliance Air Parts Acquistions Corp · Oklahoma City, OKNon-citizen corporation, flight hours not reportedBuilt 1977 · S/N LJ-753N591AWCsi 135 Division LLC · Albuquerque, NMBuilt 1995 · S/N LJ-1397N595TMRegional Air Group LLC · Windermere, FLBuilt 1990 · S/N LJ-1255N597PGuardian Flight LLC · Lewisville, TXBuilt 2000 · S/N LJ-1597N598ATWohlford Aviation LLC · Ashland, NEBuilt 1997 · S/N LJ-1499N599BB3gs Air LLC · Fort Myers, FLBuilt 1976 · S/N LJ-699N59KAParagon Office Services LLC · Dallas, TXS/N LJ-589N5TADodson International Parts Inc · Rantoul, KSBuilt 1977 · S/N LJ-724N600ACLowcountry Aviation Co Brokerage LLC · Walterboro, SCBuilt 1976 · S/N LW-185N600BFCentral Virginia Aviation Inc · Petersburg, VABuilt 1966 · S/N LJ-193N601DMR & G Aviation LLC · Hazlehurst, GABuilt 1979 · S/N LJ825N602DH2nd Amendment Wholesale Inc · Grand Forks, NDBuilt 1973 · S/N LW-44N603PACentral Virginia Aviation Inc · Petersburg, VABuilt 1968 · S/N LJ-403N606PC988sl Aviation LLC · Ridgeland, MSBuilt 1980 · S/N LJ-938N608FBVortex Education Management LLC · El Cajon, CABuilt 1979 · S/N LJ-878N60BABemidji Aviation Services Inc · Bemidji, MNS/N LW-79N60CDynamic Avlease Inc · Bridgewater, VAFirst renewal noticeBuilt 1968 · S/N LM-11N60VPGuardian Flight LLC · Lewisville, TXBuilt 1998 · S/N LJ-1516N6111VSfh Inc · Fargo, NDBuilt 2004 · S/N LJ-1711N611CRV J Coleman And Son · Ackerly, TXBuilt 1990 · S/N LJ-1234N612FN612f LLC · Henderson, TNBuilt 1989 · S/N LJ1192N613GGNcp Equipment LLC · Wilmington, DEBuilt 1998 · S/N LJ-1506N613RFB R S Leasing Inc · Wilmington, DEBuilt 1983 · S/N LJ-1068N615AASkydive San Joaquin Valley Inc · Bakersfield, CABuilt 1967 · S/N LJ-298N61698Wildfire Aviation LLC · Wilmington, DES/N LJ-1698N617MMCal-Ore Life Flight LLC · Brookings, ORBuilt 2000 · S/N LJ-1587N617RMMontana Sky Assets LLC · Helena, MTS/N LJ-1095N6190SAir Logistics LLC · Savannah, GAS/N LJ-1702N61GNGuardian Flight LLC · Lewisville, TXS/N LJ-1421N61QDynamic Avlease Inc · Bridgewater, VAFirst renewal noticeBuilt 1968 · S/N LM-92N6207FAir New England LLC · Portsmouth, NHBuilt 1982 · S/N LJ-1017N620TWStrega Ventures LLC · Boca Raton, FLBuilt 1974 · S/N LW-107N620WESouthwest Aviation Inc · Marshall, MNBuilt 1977 · S/N LJ-743N623BBAirshares Incorp · Petersburg, VABuilt 1967 · S/N LJ-277N62SALta Group Holdings LLC · Amarillo, TXBuilt 1997 · S/N LJ-1472N62VDynamic Avlease Inc · Bridgewater, VAFirst renewal noticeBuilt 1967 · S/N LM-74N640DFWhy Not LLC · Montezuma, KSBuilt 1992 · S/N LJ-1312N640RJMidwest Executive LLC · Reno, NVBuilt 1985 · S/N LJ-1106N642TDN642td LLC · Newark, DEBuilt 1978 · S/N LJ-766N643EAAir Adventures Corp · Charleston, SCBuilt 2001 · S/N LJ-1643N644JCBic Aviation LLC · Fort Smith, ARS/N LJ-698N6492CSouth River Services LLC · Myrtle Beach, SCBuilt 1982 · S/N LJ-1050
Back to AD 2002-01-10