AD 79-10-14 R1

Registered aircraft · 56,582

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-10-14-R1')
    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-10-14-R1')
  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.

N9540LCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1986 · S/N 17276574N9540TChino Aviation Inc · Chino, CABuilt 1960 · S/N 57340N9540XWhitetop Air LLC · Wilmington, DEBuilt 1985 · S/N 18268550N9541BBodick John K · Anchorage, AKBuilt 1957 · S/N 32838N9541GAllen Charles Mark · Puryear, TNBuilt 1974 · S/N 18801521N9541TNevill John D · Tahoka, TXS/N 57341N9542BSoileau Kenneth B · Lancaster, SCBuilt 1981 · S/N 172RG0867N9542HAbusham Hamed M · Upland, CABuilt 1975 · S/N 17266215N9542TLarsen Richard A · Wannaska, MNBuilt 1960 · S/N 57342N9542WState Of North Carolina · Raleigh, NCBuilt 1998 · S/N 18280136N9543ABest Alvin A · Anchorage, AKRegistration revokedBuilt 1949 · S/N 19104N9543FEvans Michael · Punta Gorda, FLBuilt 1998 · S/N 18280219N9543GHi Low Aviation LLC · Alpine, TXBuilt 1998 · S/N 18280245N9543HGonzalez-Rio Jesus A · Big Pine Key, FLBuilt 1975 · S/N 17266216N9543PHerr Bridget J · Boles, ARBuilt 1999 · S/N 17280644N9543XBarth Samuel · Fonda, NYS/N 21057843N9544ADaugherty Lee H · Charleston, WVRegistration revokedBuilt 1949 · S/N 19105N9544HSouthern Aero LLC · Homestead, FLBuilt 1975 · S/N 17266217N9544QPhoto Services Unlimited · Augusta, MEBuilt 1998 · S/N 18280291N9544SJourney Holdings LLC · Reform, ALBuilt 1998 · S/N 18280149N9544XB&B Aviation LLC · Arlington, WABuilt 1961 · S/N 21057844N9545AJetl Aviation LLC · Southern Pines, NCBuilt 1950 · S/N 19388N9545BSunrise Aero Inc · Ocala, FLBuilt 1981 · S/N 172RG0870N9545FEastern Cincinnati Aviation Inc · Batavia, OHBuilt 1998 · S/N 17280380N9545XRichardson Dana C · Okeechobee, FLBuilt 1961 · S/N 21057845N9546AStevens Scott D · Corsicana, TXS/N 19107N9546GSale Reported · Emerson, IASale reported, canceledBuilt 1974 · S/N 18263402N9546HMiller Dale L · Bozeman, MTBuilt 1975 · S/N 17266219N9546TAerographics Inc · St Cloud, MNBuilt 1960 · S/N 57346N9546XN9546x LLC · Lakeville, MNBuilt 1986 · S/N 18268551N9547AChristiansen Brent D · Mabton, WABuilt 1949 · S/N 19108N9547LCivil Air Patrol · Maxwell Afb, ALBuilt 1986 · S/N 17276575N9547WWatch Ya Head Aviation I LLC · Zionsville, INBuilt 1998 · S/N 17280508N9547XCundiff Zackery A · Klamath Falls, ORBuilt 1962 · S/N 21057847N9548GMeyer Bros Ag LLC · Algona, IABuilt 1974 · S/N 18801526TN9548WZh Aviation LLC · Wilmington, DEBuilt 1999 · S/N 17280512N9548XMclenaghan Alvin · Phoenix, AZBuilt 1962 · S/N 21057848N95494Valiair Limited Co Trustee · Casper, WYS/N 18266558N9549FJogger Industries LLC · Sherwood, NDBuilt 1998 · S/N 17280514N9549GMacica Stephen J DBA · Truckee, CABuilt 1972 · S/N U20601749N9549HBenson Edward A · San Antonio, TXBuilt 1975 · S/N 17266221N954ACAir Future Airways Corp · Miami, FLBuilt 1997 · S/N 17280053N954ASA2g International LLC · San Juan Capo, CABuilt 1980 · S/N 33701940N954CCSavvas Evangelos · Edina, MNBuilt 1976 · S/N 18265290N954ERWalker Paul Charles · Burleson, TXBuilt 1963 · S/N 336-0041N954FGRidgeline Assets LLC · Wilmington, DEBuilt 2025 · S/N 172S13279N954JAAdvanced Aviation Group LLC · Frederick, MDS/N 172S10500N954JHWings Over Texas LLC · Denton, TXBuilt 1975 · S/N 17266220N954PWWeckbacher Paul J Jr · Inverness, FLBuilt 1981 · S/N U20606288N95500Pond Scott L · Moorpark, CABuilt 1978 · S/N 18266560
Back to AD 79-10-14 R1