AD 2002-11-07

Registered aircraft · 1,512

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-11-07')
    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-11-07')
  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.

N200RTRiley Nolan C · Lubbock, TXS/N TK-101N2018LKrielow Law Firm LLC · Thibodaux, LABuilt 1978 · S/N TK-80N201DRegistered aircraftS/N TK-24N2021UAll Airline Pilot Training LLC · Delray Beach, FLBuilt 1978 · S/N TH-957N2022TAero-Marine LLC · Miramar Beach, FLBuilt 1978 · S/N TH-950N2023CFulps Aviation LLC · Winston Salem, NCBuilt 1979 · S/N TH-1012N2026WGta Air Inc · Addison, TXBuilt 1978 · S/N TH-976N2027DNichols Neil A · Aalachicola, FLBuilt 1978 · S/N TH-974N2027UJpb Diversified LLC · Auburndale, FLBuilt 1978 · S/N TH-964N20292Laflight LLC · Goldsboro, NCBuilt 1978 · S/N TH-966N202PSc Infinities LLC · Dover, DEBuilt 1998 · S/N TH-1875N2031ZJames Jeb S Dr · Bay City, TXBuilt 1978 · S/N TJ-165N2041ZBlue Mesa LLC · Bend, ORBuilt 1978 · S/N TE-1144N2043ACampion Richard · Tampa, FLBuilt 1978 · S/N TH-983N2044ABrowder Daniel Klemp · Shady Valley, TNBuilt 1979 · S/N TJ-190N204GAirmart Inc · Lexington, KYS/N TH-2042N2056NN2056n LLC · Wilmington, DEBuilt 1978 · S/N TJ-156N2058CScorpion Aviation LLC · Hemet, CABuilt 1978 · S/N TK-85N2058KCollins Jimmy · Spring, TXBuilt 1979 · S/N TK-66N2059PNiemi Aviation LLC · Glyndon, MNBuilt 1998 · S/N TJ-159N2059XK Wings LLC · Golden Valley, MNBuilt 1978 · S/N TH-994N205AGWing Men LLC · Cleveland, OHBuilt 1974 · S/N TH-516N205KTMha Interests LLC · Spring, TXBuilt 1981 · S/N TH-1286N20602Bromschwig Kurt F Trustee · Montgomery, TXS/N TJ-173N2061KMile High Air Inc · Canyon, TXBuilt 1978 · S/N TJ-161N2063GHolman Allen S · Knoxville, TNBuilt 1979 · S/N TH-1002N2064VGta Air Inc · Addison, TXBuilt 1979 · S/N TH-1004N2069KFiloteo James · Woodinville, WABuilt 1978 · S/N TK-74N2069YBeach Helicopter Services LLC · Chesapeake, VABuilt 1979 · S/N TK-76N2070LBaron 70 Lima LLC · Modesto, CABuilt 1976 · S/N TH-753N2073LBravo Wings II LLC · Grants, NMBuilt 1976 · S/N TJ-73N207ZMInternational Air Services Inc Trustee · Carson City, NVBuilt 1993 · S/N TH1677N2082LChronicle Aerospace Inc · Wilmington, DEBuilt 1976 · S/N TK-20N208PGrateful Center Transportation LLC · Lutz, FLBuilt 1991 · S/N TH-1626N210DAStroemsvik Kristian · Strasburg, VABuilt 1979 · S/N TH-1067N2110AWindshear Aviation LLC · Longmont, COBuilt 1977 · S/N TJ-129N2110LMalco Power Design Co Inc · La Marque, TXS/N TH-761N2119LCannon Thomas W · Tiki Island, TXBuilt 1976 · S/N TH-759N211AA1776 Aviation LLC · Kalispell, MTBuilt 1976 · S/N TE-1078N211MWGoad Jerry A · Oneida, TNBuilt 1973 · S/N TE-923N212ASKff Inc · Piscataway, NJBuilt 2001 · S/N TH-1995N212CHFlycarolina Ll · Concord, NCBuilt 1980 · S/N TH-1165N212PPLermer Christoph · Naples, FLBuilt 1990 · S/N TH-1604N212TWLeaving On Tulsa Time LLC · Tulsa, OKBuilt 2000 · S/N TH-1950N2130LTds Property Holdings LLC · Gilmer, TXBuilt 1976 · S/N TK-25N213CHEz Aviation LLC · Morrisville, NCS/N TH-2079N2143JTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1998 · S/N TH-1855N2146LDm Group LLC · Troutman, NCBuilt 1976 · S/N TH-778N214CHFlycarolina LLC · Concord, NCBuilt 1980 · S/N TH-1160N214KPBnb Aviation LLC · Chesterfield, MOBuilt 1999 · S/N TH-1894
Back to AD 2002-11-07