AD 79-08-06

Registered aircraft · 5,263

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:79-08-06')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:79-08-06')
  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.

N136DCStreamline Aviation LLC · Battlefield, MOBuilt 1982 · S/N 136N136YJanoski David M · Fort Worth, TXBuilt 1960 · S/N 24-1991N137MWMcphillips Flying Service Inc DBA · Beaver Island, MIBuilt 1970 · S/N 137N138ABAerial Banners Inc · Pembroke Pines, FLBuilt 1966 · S/N 25-3915N138LWIsland Air Charters Inc · Ft Lauderdale, FLBuilt 1978 · S/N 138N13BRC-140 Co LLC · Pensacola, FLBuilt 1963 · S/N 27-532N13FDSkythrills! LLC · Fullerton, CABuilt 1975 · S/N 10-09N13RGIsland Piper Llp · St Helena Is, SCBuilt 1972 · S/N 28-7310055N140JGBarros Vincent · Kissimmee, FLBuilt 1974 · S/N 32-7400043N141DDCox Aviation Services LLC · Acworth, GABuilt 1999 · S/N 3246132N1424MFly High LLC · Mobile, ALBuilt 1973 · S/N 32-7300043N1426THillcrest Of Central Fl LLC · Auburndale, FLBuilt 1972 · S/N 32-7200038N142CATack Kenneth W · Taft, CABuilt 1959 · S/N 24-1161N143LWMurphy Law Office Pc · Rapid City, SDBuilt 1979 · S/N R18201265N143TBSmith Timothy T · Turkey, NCBuilt 1979 · S/N 28-8011053N143ZLYoder F David · Wellington, FLBuilt 1999 · S/N 0030N1440XAlldredge Brad · Redlands, CABuilt 1963 · S/N 24-3478N144CDLittle Gator Aviation Inc · Fairfield, NCBuilt 1999 · S/N 0602N144DSStevenson William E · Sutton, AKBuilt 2000 · S/N 0715N144EZFlorida Aviation LLC · Tallahassee, FLS/N 32R-7885184N144FLSouth Florida Helicopters Inc · Indiantown, FLS/N 0654N144JGMontana Aircraft Trust Inc Trustee · Bozeman, MTBuilt 2000 · S/N 0859N144MNHaynes Michael W · Odessa, TXBuilt 2006 · S/N 1555N144RFRio Farms LLC · King City, CABuilt 2002 · S/N 1223N144RPBenrud Aviation LLC · Rice, MNS/N 0766N144WBUniversal Aviators Academy Inc · El Monte, CABuilt 1998 · S/N 0545N144WTPerformancez LLC · Nederland, TXS/N 0601N1450XHopkins David M · Bell Buckle, TNBuilt 1975 · S/N 32-7500042N145ABAerial Banners Inc · Pembroke Pines, FLBuilt 1965 · S/N 25-3137N145RHFlying L Aircraft Inc · Fort Denaud, FLBuilt 1986 · S/N 1N1465TCaudle Tommie A · Bentonville, ARBuilt 1972 · S/N 32-7200040N146LWBelvedere Inc · Marion, IABuilt 1979 · S/N 287911236N146PWilliams Mike C · Sonora, TXS/N 24-366N146SCFantasy Aire Inc · Wilmington, DEBuilt 1968 · S/N 32-985N147ECAarow Aircraft Leasing LLC · Mcminnville, ORBuilt 1963 · S/N 27-2399N1489TLion Aviation LLC · Kansas City, MOBuilt 1972 · S/N 32-7200042N1490XTwin Peaks Holdings · Midvale, UTBuilt 1975 · S/N 28-7510095N1497XTundra Toyo And Heating LLC · Nome, AKBuilt 1975 · S/N 32-7500038N14BEBelmont Circle LLC · Virginia Beach, VABuilt 1979 · S/N 28-7911322N14EE14ee Corp · Cranberry Township, PABuilt 1978 · S/N 13117N14FCJwc59 LLC · Newnan, GABuilt 1959 · S/N 24-924N14MTSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1979 · S/N R18201227N14MYSouth Florida Helicopters Inc · Indiantown, FLS/N 1149N14RWJohnston Jeffrey T · Ramsey, MNS/N 28-10217N150BRegistered aircraftBuilt 2002 · S/N 1199N150BJDakota Air LLC · Delray Beach, FLBuilt 1983 · S/N 28-8311013N15126Registration Pending · Mc Caysville, GARegistration pendingBuilt 1972 · S/N 32-7300002N15134Roe Robert D Jr · Naples, FLBuilt 1972 · S/N 32-7300003N15152Meyer Kendra · Ankeny, IABuilt 1972 · S/N 28-7310015N15153Kyzer Stacey A · Fort Mill, SCBuilt 1972 · S/N 28-7310016
Back to AD 79-08-06