AD 2007-06-07

Registered aircraft · 1,100

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:2007-06-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:2007-06-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.

N191LRRoutman Leone Aircraft LLC · Fort Lauderdale, FLBuilt 1994 · S/N TH-1720N198BArkla Aviation LLC · Farmerville, LABuilt 2000 · S/N TH-1936N19LPZelta LLC · Wilmington, DEBuilt 2016 · S/N TH-2473N1MFWise Christopher J · Plano, TXS/N TH-835N1MQGc4 Aero LLC · Birmingham, ALBuilt 1976 · S/N TH-731N2021UAll 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-1875N2043ACampion Richard · Tampa, FLBuilt 1978 · S/N TH-983N204GAirmart Inc · Lexington, KYS/N TH-2042N2059XK 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-1286N2063GHolman Allen S · Knoxville, TNBuilt 1979 · S/N TH-1002N2064VGta Air Inc · Addison, TXBuilt 1979 · S/N TH-1004N206BKGo Best Inc · Richmond Hill, GABuilt 2014 · S/N TH-2413N2070LBaron 70 Lima LLC · Modesto, CABuilt 1976 · S/N TH-753N207ZMInternational Air Services Inc Trustee · Carson City, NVBuilt 1993 · S/N TH1677N208PGrateful Center Transportation LLC · Lutz, FLBuilt 1991 · S/N TH-1626N210DAStroemsvik Kristian · Strasburg, VABuilt 1979 · S/N TH-1067N2110LMalco Power Design Co Inc · La Marque, TXS/N TH-761N2119LCannon Thomas W · Tiki Island, TXBuilt 1976 · S/N TH-759N212ASKff 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-1950N213CHEz 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-1894N2150LB-58 Inc · Albany, GAS/N TH-781N215GTInsulation By Cohens LLC · Moncks Corner, SCS/N TH-2439N215MBEta Flyers Aviation LLC · Florida, NYS/N TH-2133N218KAR3 Aviation LLC · Miami Lakes, FLBuilt 2009 · S/N TH-2267N219CHSteel Eagle Aviation LLC · Birmingham, ALBuilt 2001 · S/N TH-1990N219GMStewart Michael A · Washington, DCBuilt 1988 · S/N TH-1536N219TBAir Fins LLC · Wilmington, DEBuilt 2007 · S/N TH-2197N21DAW Squared Holdings LLC · Edmond, OKBuilt 1978 · S/N TH-980N21LPLp Aviation Inc · Wilmington, DEBuilt 1977 · S/N TH-848N21MFOsgood Air LLC · Hays, KSBuilt 1998 · S/N TH-1871N21YMCape Fear Transport Inc · Elizabethtown, NCS/N TH-2005N221CHBas Part Sales LLC · Greeley, COS/N TH-2103N2224DHanger South Aviation LLC · Paragould, ARS/N TH-1824N222RBwr Aircraft LLC · Paramus, NJBuilt 2001 · S/N TH-1977
Back to AD 2007-06-07