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

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

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.

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

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

N175TGMoschetti Flight Outfitters LLC · Kingston, WABuilt 1958 · S/N 55081 N175THLa France Edward J · Ellensburg, WABuilt 1960 · S/N 56237 N175TTFarrell Dolliver T · Sterling, AKBuilt 1958 · S/N 55193 N175TWSalyer Robert O · Nashville, TNS/N 55360 N175UKChase Michael E Trustee · Montague, MIS/N 55829 N175VCCashmere Aviation LLC · Mcalester, OKBuilt 1960 · S/N 17556798 N175WRMcgraw Jeff M · Denver, COBuilt 1959 · S/N 56404 N1760FPark Rapids Avionics Inc · Park Rapids, MNBuilt 1966 · S/N 17255155 N1760MCoggin Patric D · Fort Smith, ARBuilt 1975 · S/N 18264427 N1760TFlight Operations Aircraft LLC · Wilmington, DEBuilt 2017 · S/N 172S12108 N1761FTuttle Trent · Deforest, WIS/N 17255156 N1762TFlight Operations Aircraft LLC · Wilmington, DEBuilt 2017 · S/N 172S12109 N1763MHaines Robert F · Carlsbad, CABuilt 1975 · S/N 18264429 N1763XRobins Nest Aviation LLC · Harrison, OHBuilt 1975 · S/N 21060784 N1764CRyan Michael · Gillette, WYS/N 30464 N1764VGross John F · Winthrop, MEBuilt 1974 · S/N 17263743 N1764XLeschber Larry · Hutto, TXBuilt 1975 · S/N 21060785 N17651Basler Turbo Conversions LLC · Oshkosh, WIS/N R172-0137 N1765FKohler Daniel J · Mapleton, ORS/N 17255160 N1765MFlying Cow LLC · Syracuse, NYBuilt 1975 · S/N 18264430 N1766MN1776m LLC · Panama City, FLBuilt 1975 · S/N 18264431 N1766TFlight Operations Aircraft LLC · Wilmington, DEBuilt 2017 · S/N 172S12110 N1766VCode4 Ventures Inc DBA · Waynesboro, VABuilt 1974 · S/N 17263744 N1767MAnderson Thomas C Trustee · Sun City West, AZBuilt 1975 · S/N 18264432 N1767RHamel David A · Klamath Falls, ORBuilt 1974 · S/N 18502487 N1768MWyoming Valley Air LLC · Old Forge, PAS/N 33701368 N1768QHarper John T · Fairfield, OHBuilt 1971 · S/N 15073068 N1768VBrown Craig D · Fort Wayne, INBuilt 1974 · S/N 17263745 N1768ZMoskowitz Craig B · Sheffield, MABuilt 1963 · S/N 336-0068 N1769QPmn Enterprises LLC · Fremont, WIBuilt 1971 · S/N 15073069 N1769RCt Aviation LLC · Waverly, NEBuilt 1974 · S/N 18502489 N176BLChristiansen Aviation LLC · Wilmington, DEBuilt 2013 · S/N 172S11287 N176EAHeath Mark R · Radisson, WIS/N R172-3440 N176ERSkywarrior Flight Training LLC · Pensacola, FLS/N 17269507 N176LGTita Enterprises LLC · Apex, NCS/N 172RG0074 N176LLClear Above LLC · Haymarket, VABuilt 1975 · S/N 21061135 N176MEEastern Cincinnati Aviation Inc · Batavia, OHBuilt 2000 · S/N 172S8470 N176TAGeorge'S Aviation Services Inc · Honolulu, HIBuilt 2018 · S/N 172S12115 N176TCRedtail Cirrus LLC · Boise, IDBuilt 1979 · S/N 18503814 N176YCessna U206f Aviation LLC · Boise, IDS/N U206-03383 N1770RRegistered aircraftBuilt 1974 · S/N 18502490 N1770XPark Avenue Group Inc · Stuart, FLBuilt 1975 · S/N 21060791 N1771MGaley Matthew Blake · Greenwood, MSBuilt 1975 · S/N 18264433 N1772FTia Aviation LLC · Hot Springs, ARBuilt 1966 · S/N 17255167 N1773BBaney Robert P · Philipsburg, PABuilt 1977 · S/N 17702730 N1773DReeves Stephen E · Palm Harbor, FLBuilt 1951 · S/N 20216 N1773FRegistration Pending · Jasper, ALRegistration pendingBuilt 1966 · S/N 17255168 N1773ZMcclay David H · Lagrande, ORBuilt 1963 · S/N 336-0073 N1774CStol LLC · Fort Wayne, INBuilt 1953 · S/N 30474 N1774DDj Brandt LLC · Cedar City, UTS/N 17702028

Back to AD 79-10-14 R1