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.

N1604WSteve Byrd Aviation LLC · Terrell, TXBuilt 1972 · S/N TH-242N1629WRegistered aircraftN-number assigned, not yet registeredS/N TH-245N1648WKings Aviation Corp · Garden City, NYBuilt 1972 · S/N TH-251N164MDehaan David J · San Diego, CABuilt 2010 · S/N TH-2295N166BVSensing Aviation LLC · Nashville, TNBuilt 2000 · S/N TH-1958N1673WOci Ltd · Brunswick, GABuilt 1972 · S/N TH-258N167TRBarton Aviation LLC · San Antonio, TXBuilt 1998 · S/N TH-1849N168CCLanham Aviation LLC · Simpsonville, KYBuilt 1990 · S/N TH-1606N169LALee Arnold Management Services Inc · Clearwater, FLBuilt 2017 · S/N TH-2494N169RRGerlach & Associates LLC · Valparaiso, INBuilt 1979 · S/N TH-999N16BKWc Aviation LLC · Forest, VABuilt 2012 · S/N TH-2335N16DADonaire Aviation LLC · Tampa, FLBuilt 1974 · S/N TH-501N16PMcmurray Justin John · Durham, NCBuilt 1999 · S/N TH-1925N16PVAlign Aviation LLC · The Woodlands, TXBuilt 2006 · S/N TH-2144N1710ABald Mtn LLC · Modesto, CABuilt 2016 · S/N TH-2462N172DHSanta Lucia 930 LLC · Greenwich, CTBuilt 2014 · S/N TH-2403N174URocky Mountain Ventures Inc · Cheyenne, WYBuilt 1970 · S/N TH-73N1756SRed Rocket LLC · Greenville, NCS/N TH-2301N17660Simpson Chad · Harrison, ARBuilt 1977 · S/N TH-810N176RKY-12 Investments LLC · Alexandria, VABuilt 2020 · S/N TH-2532N17833Mccall Edmund B · Portland, ORBuilt 1977 · S/N TH-827N17979Alford Flying LLC · Wichita, KSBuilt 1977 · S/N TH-832N17980Rowles Robert · Pittsfield, ILBuilt 1977 · S/N TH-840N17BRJds Management Co LLC · Warner Robins, GABuilt 1983 · S/N TH-1372N1807NDouble Barrel Aviation LLC · Fort Valley, GABuilt 1981 · S/N TH-1263N1810XAviation Trust Company LLC Trustee · Oklahoma City, OKS/N TH1266N18142Aviation Trust Co LLC · Oklahoma City, OKBuilt 1981 · S/N TH-1270N1817SClear Skies LLC · Stuart, FLBuilt 1981 · S/N TH-1271N1827LCone James R Jr · Lubbock, TXS/N TH-741N18296Star Flight Aviation Inc · Shreveport, LABuilt 1977 · S/N TH-844N1829ECorporate Airtime LLC · Clinton, MSBuilt 1981 · S/N TH-1282N18320Cox Jack H Jr · Arlington, TXBuilt 1977 · S/N TH-849N18351Iowa Great Lakes Flyers Ltd · Cheyenne, WYBuilt 1977 · S/N TH-855N18358Life Is A Beech LLC · Los Lunas, NMFirst renewal noticeBuilt 1977 · S/N TH-814N18361Landvater Darryl V · Williston, VTBuilt 1981 · S/N TH-1290N18364Goeken Peter C · Dakota Dunes, SDBuilt 1977 · S/N TH-854N18386Gamco Aviation LLC · Shreveport, LABuilt 1977 · S/N TH-856N18475Gerlach And Associates LLC · Valparaiso, INBuilt 1977 · S/N TH-879N1852WDavis Sean · Carlisle, IABuilt 1973 · S/N TH-329N1854RSellers William G III · Troy, ALBuilt 1982 · S/N TH-1345N185ARortvedt Robert S · Mukwonago, WIBuilt 1973 · S/N TH-332N186VBLatb LLC · Lewes, DEBuilt 1981 · S/N TH-1239N18748Board Of Trustees Of Southern Illinois Univ · Carbondale, ILS/N TH-875N18752Morgantown Flying Club LLC · Morgantown, WVBuilt 1977 · S/N TH-877N1889WSabre 65 LLC · Helena, MTBuilt 1973 · S/N TH-341N1895LPalm Group LLC · Metairie, LABuilt 1977 · S/N TH-894N18HMYoung Craig · Ada, MIBuilt 1975 · S/N TH-651N18VRVentura Air LLC · Wilmington, DEBuilt 1996 · S/N TH-1771N1901LBerry Darrel · Camden, TNBuilt 1976 · S/N TH-754N190RSBas Part Sales LLC · Greeley, COBuilt 1977 · S/N TH-804
Back to AD 2007-06-07