AD 79-19-06

Registered aircraft · 1,401

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-19-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-19-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.

N123DMJacquin Philip Fink · New York, NYS/N 21062663N123VRLewis Edward M · Mesquite, NVS/N 210-59891N125BMBaron Transporation Services LLC · Destrehan, LAFirst renewal noticeBuilt 1978 · S/N 21062926N126LSMerritt Aaron S · Manhattan, MTS/N 21062038N128EEAlgab Holdings LLC · Newark, DEBuilt 1978 · S/N P21000133N1299MMoanaviation Inc · Tampa, FLBuilt 1977 · S/N 21061932N12JGVosworx Aviation LLC · Morrison, COBuilt 1979 · S/N P21000365N12KFN12kf LLC · Pass Christian, MSBuilt 1973 · S/N 21059853N12PFRucker Gary R · Kingman, AZBuilt 1977 · S/N 21062401N12PWOhio State University College Of Engineering · Columbus, OHBuilt 1972 · S/N 21059796N12VMS & R Air Inc · Asheville, NCBuilt 1977 · S/N 21061697N130RCWilliams Brian G · Las Cruces, NMBuilt 1983 · S/N P21000822N1397MRichs Inc · Wilmington, DES/N 21061940N13KSNolt Ivan · Mount Solon, VABuilt 1974 · S/N 21060202N13TNMcdaniel Robert M · Tonasket, WABuilt 1977 · S/N 21062428N1400Salour Michael M · Carlsbad, CABuilt 1979 · S/N P210-00277N144WPDresel Av LLC · Fayetteville, ARBuilt 1973 · S/N 21059900N14JEN14je LLC · White Springs, FLBuilt 1975 · S/N 21060792N151MTIsland Mountain Aviation LLC · Vesta, MNBuilt 1973 · S/N 21059861N152BTCoho Aviation LLC · Hillsboro, ORBuilt 1980 · S/N P21000486N1574PSouthern Seaplane Inc · Belle Chasse, LABuilt 1976 · S/N 21061258N1576MSkyline Aviation Services LLC · Miramar, FLBuilt 1977 · S/N 21061948N15CWN15cw LLC · Wilmington, DEBuilt 1983 · S/N P21000824N15DACamborne USA LLC · Collierville, TNS/N 21061765N15MLN15ml LLC · Cresskill, NJBuilt 1977 · S/N 21061780N15USFlypower Inc · Fort Lauderdale, FLBuilt 1975 · S/N 21060676N1600XLd&B LLC · Show Low, AZS/N 21060636N1605MSelter Eric Jay Trustee · Agoura Hills, CABuilt 1977 · S/N 21061950N1609XHarvey P J · Midland, TXBuilt 1975 · S/N 21060645N1615XBvi Aviation LLC · Wilmington, DEBuilt 1975 · S/N 21060651N1633XRhodes Donald P · Fort Worth, TXBuilt 1975 · S/N 21060669N1634XBadwater Ranch Inc · Lysite, WYBuilt 1975 · S/N 21060670N1636XMonke Farm & Cattle Co · Nickerson, NEBuilt 1975 · S/N 21060672N163CLJust Saying Construction LLC · Merritt Island, FLS/N 21062122N1651XPeters Mark E · Newport News, VABuilt 1975 · S/N 21060686N1652XBlackbridge Holdings LLC · Helena, MTBuilt 1975 · S/N 21060687N1655XApostolou Gregory · Henderson, NVBuilt 1975 · S/N 21060690N1656XAnderson George E · Newnan, GABuilt 1975 · S/N 21060691N1657XRowe William W · Provo, UTBuilt 1975 · S/N 21060692N1675XNo Runways LLC · Iraan, TXBuilt 1975 · S/N 21060710N1676XSkydancer Le LLC · Wilmington, DEBuilt 1975 · S/N 21060711N1678XFly Guys LLC · Arcata, CABuilt 1975 · S/N 21060713N1679XBouchereau Raymond Jr · San Dimas, CABuilt 1975 · S/N 21060714N1687XMorton Douglas E · Cody, WYBuilt 1975 · S/N 21060722N168SDCometenterprises.Net LLC · Kalispell, MTBuilt 1979 · S/N P21000460N1696XCenturion LLC · New Bern, NCBuilt 1975 · S/N 21060731N1698XCmo Blue Sky LLC · Tomball, TXS/N 21060733N169JMBravo Alpha LLC · Driggs, IDBuilt 1978 · S/N P21000169N1716XBell Brian · Oakland, CABuilt 1975 · S/N 21060738N1720XKregel Brian D · Garnavillo, IABuilt 1975 · S/N 21060742
Back to AD 79-19-06