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.

N135FBSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1977 · S/N TH816N137JPRitec LLC · Sandown, NHBuilt 1982 · S/N TH-1322N13AKTailwinds Inc · Toms River, NJBuilt 1975 · S/N TH-678N13TWSouthern Aerial Service LLC · Douglas, GABuilt 1985 · S/N TH-1468N140SGta Air Inc · Addison, TXBuilt 1980 · S/N TH-1155N141PCCleggs Termite And Pest Control · Morehead City, NCS/N TH-2091N142DRHj & L Air LLC · Sacramento, CABuilt 1985 · S/N TH-1458N142SMed Care Inc · Grand Island, NEBuilt 1975 · S/N TH-693N142TWInternational Air Services Inc Trustee · Carson City, NVBuilt 1998 · S/N TH-1841N148DSEast Ramp Aviation LLC · Baton Rouge, LABuilt 1986 · S/N TH-1439N14AJChalk 2 Inc · Apple Valley, CABuilt 1980 · S/N TH-1154N14CEFacility Concepts Developments LLC · Jackson, MSBuilt 1989 · S/N TH-1562N14JHRegistered aircraftBuilt 1998 · S/N TH-1845N14XMMedical Diagnostic Imaging Inc · Sacramento, CABuilt 1976 · S/N TH-758N1511WFlorida Float Plane LLC · Coral Gables, FLBuilt 1972 · S/N TH-217N1515WCenturionair LLC · Greenville, SCBuilt 1972 · S/N TH-218N1526MGarmin At Inc · Salem, ORBuilt 1994 · S/N TH-1711N1545WM T Air LLC · Olive Branch, MSBuilt 1989 · S/N TH-1545N1557W557 Whiskey LLC · Superior, WIBuilt 1972 · S/N TH-229N1560YPacific Integrated Handling · Tacoma, WABuilt 1994 · S/N TH-1717N1564LWhipple Cory · Senatobia, MSBuilt 1976 · S/N TK-6N1566KShaw David C · Santa Barbara, CABuilt 1989 · S/N TH-1549N1566W66 Whiskey LLC · Atlanta, GABuilt 1994 · S/N TH-1713N1567NAuburn Simflight LLC · Auburn, ALBuilt 1989 · S/N TH-1567N15688Moses & Associates Inc · Gainesville, FLBuilt 1988 · S/N TH-1542N1570NUp N Down Adventures LLC · Calera, OKBuilt 1994 · S/N TH-1715N157JRSoft Landings LLC · Myrtle Beach, SCBuilt 1991 · S/N TH-1639N158BBStubbs J Phillip · Richmond, VABuilt 1975 · S/N TH-592N158BDJ L Aviation LLC · Jonesboro, ARBuilt 1979 · S/N TH-1045N158BHB58 LLC · Granger, INBuilt 1988 · S/N TH-1540N158BJPerfectus Inc · Wilmington, DES/N TH-324N158BMChorman Spraying LLC · Milton, DEBuilt 1981 · S/N TH-1244N158DGAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2016 · S/N TH-2460N158EAElevation Air Capital LLC · Janesville, WIS/N TH-2542N158KPelican Aviation Inc · Gainesville, GABuilt 1980 · S/N TH-1178N158LFPro Tech Track & Tennis Management Lp · Bullard, TXBuilt 2014 · S/N TH-2425N158MRT-Bird LLC · Byron Center, MIBuilt 2011 · S/N TH-2312N158MST Hiers LLC · Barney, GABuilt 2017 · S/N TH-2492N158NCIal Corp · Lewes, DEBuilt 1974 · S/N TH-444N158PA2 Laikas LLC · Helena, MTBuilt 1978 · S/N TJ-141N158PCSewalt Steve · Victoria, TXBuilt 2018 · S/N TH-2500N158RFBeech Bound LLC · Morgantown, WVBuilt 1978 · S/N TH-941N158RMWings Lc · Baltimore, MDBuilt 1988 · S/N TH-1543N158RWHeartfield J Thad · Beaumont, TXBuilt 2008 · S/N TH-2221N158SWFern Leasing Corp · Larkspur, CABuilt 1999 · S/N TH-1921N158TBLunt Christopher K · Marco Island, FLBuilt 1977 · S/N TH-826N158WCKing Air Properties LLC · Huntington Beach, CABuilt 2001 · S/N TH-2008N158YBCommercial Bank Aviation LLC · Harrogate, TNBuilt 2014 · S/N TH-2410N159SMMcneill Transportation LLC · Whiteville, NCS/N TH-2085N1604MMckinney John Merrill Jr · Bessemer, ALBuilt 1983 · S/N TH1359
Back to AD 2007-06-07