OpenAirDocs.org
AD 79-10-14 R1

Registered aircraft · 56,578

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.

N1883QMitchell Philip J · Arlington, TXS/N 177RG0283N1884MMontgomery Aviation LLC · Zionsville, INBuilt 2005 · S/N 172S9931N1884VMurphy Edward L · Fairmont, WVBuilt 1974 · S/N 17263781N1884XKaines John L · Ludington, MIBuilt 1965 · S/N 18255984N1885CZibell David H · Olympia, WABuilt 1953 · S/N 26029N1885MLittle Dog Aviation LLC · Anchorage, AKBuilt 1975 · S/N 18264468N1885QHansen Peter J · New Iberia, LABuilt 1972 · S/N 177RG0285N1886VAngelone Inc · Elkhart, INBuilt 1974 · S/N 17263782N1887CRiggs Eugene D · Shoreline, WAS/N 26031N1887FHeadings Kevin · Echo, ORS/N 21058787N1887QLosyad LLC · Sanford, FLBuilt 1972 · S/N 177RG0287N1887ZDavidson David R · Sutton, AKS/N 205-0087N1888CWayman Ian A · Peyton, COBuilt 1953 · S/N 26032N1888QAmerican Aerial Photos LLC · Efland, NCBuilt 1972 · S/N 177RG0288N1889CKlindworth Bo N · Beulah, NDBuilt 1953 · S/N 26033N1889FPiper Henry Burton Jr · Kingston, TNBuilt 1966 · S/N 21058789N1889QRuff Randall N · Bay City, MIBuilt 1972 · S/N 177RG0289N1889VCroome James Earl Jr · Sandersville, GABuilt 1974 · S/N 17263783N188AHAlf Ix LLC · Chicago, ILBuilt 2026 · S/N 172S13467N188CRempfer David Dwayne · Chandler, AZS/N 27104N188CACivil Air Patrol · Maxwell Afb, ALBuilt 2024 · S/N 18283260N188CPCivil Air Patrol · Maxwell Afb, ALBuilt 2012 · S/N 18282343N188HS&T Aviation LLC · Santa Teresa, NMS/N 50652N188MESenior Mi LLC · Batavia, ILBuilt 2000 · S/N 20608108N188PLe Duc Richard Steven · Mazama, WABuilt 1963 · S/N P17257122N188VEFly Skyhawk LLC · Peoria, AZBuilt 2000 · S/N 172S8391N189Jones William Cody · Roxton, TXS/N P3370209N1890MPutney Bruce N · Midlothian, TXS/N 33701490N1890ZAlaniz Jose M · Yreka, CABuilt 1962 · S/N 205-0090N1891CCoetzee Theo · San Luis Obispo, CABuilt 1953 · S/N 26035N1891MStarkman Timothy S · Monterey, CABuilt 1975 · S/N 18264470N1891YCarolina Sky LLC · Rock Hill, SCBuilt 1962 · S/N 17249491N1892FPanagotacos George · Corona, CABuilt 1966 · S/N 21058792N1892VSmith Air Inc · Ukiah, CABuilt 1974 · S/N 17263784N1892XCuvar Philip M · Granite City, ILBuilt 1965 · S/N 18255992N1892YBaker David Laurence · Nelson, WIS/N 17249492N1893CFife Christopher R · Winslow, MEBuilt 1953 · S/N 26037N1893FKleeman Mark · Kearney, MOFirst renewal noticeS/N 21058793N1893QSauk Prairie Aviators LLC · Merrimac, WIBuilt 1972 · S/N 177RG0293N1893YWhelan John J · Mount Vision, NYBuilt 1962 · S/N 17249493N1894XCorso Aviation LLC · Southlake, TXBuilt 1964 · S/N 18255994N1894ZEverly Peter · Fort Smith, ARBuilt 1962 · S/N 205-0094N1896BSmart John B III · Southlake, TXBuilt 2005 · S/N 18281731N1896CGladish Jeffrey · Terrell, TXBuilt 1953 · S/N 26041N1896XSmr Holdings LLC · Martinsburg, WVBuilt 1964 · S/N 18255996N1896YArmond Richard Joseph · Thousand Oaks, CABuilt 1962 · S/N 17249496N1897CBentley Eric T · Farmersville, TXBuilt 1953 · S/N 26042N1897QGuadarrama Joe R · Vacaville, CABuilt 1972 · S/N 177RG0297N1897VBarxbar Aviation LLC · Mesa, AZBuilt 1974 · S/N 17263785N1898ZSmart Robbie A · Wasilla, AKBuilt 1962 · S/N 205-0098
Back to AD 79-10-14 R1