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.

N528NDAerosim Academy Inc · Sanford, FLBuilt 2008 · S/N 172S10825N528PVMelin Mark Alan · Newport, NCBuilt 2007 · S/N 18282035N528SCMaxxum Financial Group Inc · Destrehan, LABuilt 2002 · S/N 172S9210N528STStanlake Lowell P · Grand Forks, NDBuilt 1972 · S/N 17260868N528SVFox Leasing Group LLC · Hollywood, FLBuilt 2004 · S/N 172S9754N52907Hatcher James A · Hilltop Lakes, TXBuilt 1974 · S/N 18262943N52908Ichinose Ryan · Fort Worth, TXBuilt 1977 · S/N 177RG1306N5290ESpacely Space Sprockets LLC · Aurora, ORBuilt 2002 · S/N 172S9226N5290HLevy James L · Clifton Park, NYBuilt 2002 · S/N 172S9230N5290QSaso Jan D · Hughson, CABuilt 1972 · S/N 15073190N5290VSpartan Education LLC · Tulsa, OKBuilt 2010 · S/N 172S11025N52916Boston Center Flying Club Inc · Dracut, MABuilt 1974 · S/N 18262949N52919Tucker Benny L · Thomaston, GABuilt 1974 · S/N 18262952N5291ALewis Aeronautical LLC · San Antonio, TXBuilt 2009 · S/N 172S11021N5291DJacobson Anthony P · Wasilla, AKBuilt 1958 · S/N 50189N5291EBreslin Denis M · El Cajon, CABuilt 1978 · S/N 17271820N5291NJdb Aviation LLC · Topeka, KSBuilt 1980 · S/N 18267623N5291QQuinn Robert J · Kelleys Island, OHBuilt 1972 · S/N 15073191N5291TGodin David M · Levant, MEBuilt 1959 · S/N 50553N5291WMaxxum Financial Group Inc · Destrehan, LABuilt 2002 · S/N 172S9234N52922Northwest Flyers Inc · Marianna, FLBuilt 1981 · S/N 17274635N52923Grinton Harry M · Arvada, COBuilt 1974 · S/N 18262955N5292DAftcloud Inc · Ontario, CAS/N 17272497N5292EJam Three LLC · Saint George, UTBuilt 1978 · S/N 17271821N5292KBates Field Aero Club Inc · Mobile, ALBuilt 1980 · S/N 17274048N5292NGoicoechea Mitchell Trustee · Elko, NVBuilt 1980 · S/N 18267624N5292REss Adventures LLC · Damascus, ARBuilt 1974 · S/N 17263506N52930Sir Grantham Of Kloofbear Inc · Wilmington, DEBuilt 1977 · S/N 177RG1312N52936Reimer Dean R · Yuma, AZBuilt 1978 · S/N 177RG1313N52939Warwas Steven M · Yorktown, TXBuilt 1981 · S/N 17274641N5293KBrooks Jimmy · O Fallon, ILS/N 17274049N5293QRoberts Jeffrey E · Wheeling, WVBuilt 1972 · S/N 15073193N5293XBaker Leasing LLC · Kotzebue, AKS/N U20605612N52940Schickner Michael J · Mesa, AZBuilt 1974 · S/N 18262964N52942Origer Deborah F · Albany, ORS/N 18262966N52944Masiero Christophe D · Winter Garden, FLBuilt 1978 · S/N 177RG1315N52946Pluntze Stephen C · El Segundo, CABuilt 1977 · S/N 177RG1317N5294RRemus Stephen J · Warren, MIBuilt 1974 · S/N 17263508N5294WSonneborn Arthur Aaron · East Leroy, MIBuilt 2003 · S/N 17281186N52950Jin Jin Aviation LLC · Anchorage, AKBuilt 1981 · S/N 17274642N52953Pacific Fleet Aviation LLC · Rochester, NYBuilt 1981 · S/N 17274644N52957Koch Eric C · Charlotte, NCBuilt 1974 · S/N 18262973N52959Triple T Metal Corp · Bryantsville, KYBuilt 1974 · S/N 18262975N5295ETimbers Flying Club · West Branch, MIFirst renewal noticeBuilt 1978 · S/N 17271824N5295GJohnston Robert · Hico, TXBuilt 1979 · S/N 17273559N5295NHillcrest Emergency Physicans Inc · Tulsa, OKBuilt 1980 · S/N 18267627N52963Union Movie Works LLC · Sacramento, CABuilt 1974 · S/N 18262976N5296DZack Gary J · Sunderland, VTS/N 172S9239N5296KTorres Ruben E · Toa Alta, PRBuilt 1980 · S/N 17274050N5296QSun Baron · Arcadia, CABuilt 1972 · S/N 15073196
Back to AD 79-10-14 R1