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.

N2561UNeinast Jeffrey J · Olton, TXBuilt 1963 · S/N 17250161 N2561XN343ga Leasing LLC · Anchorage, AKBuilt 1965 · S/N P206-0061 N2562DWalker Garrett J · Anchorage, AKBuilt 1952 · S/N 20714 N2562LWilkey Paul W · Sullivan, INBuilt 1967 · S/N 17255762 N2562QStiles Thomas W · Pocahontas, ILBuilt 1966 · S/N 18257762 N2562RKehler Grain & Livestock · Saint Xavier, MTBuilt 1967 · S/N 18258262 N2563JKrebs Charles · Suwannee, FLFirst renewal noticeBuilt 1964 · S/N 15061063 N2563SClements Kenneth Brian · Las Vegas, NVBuilt 1976 · S/N 21061330 N2563VSchneider Gregory M · Bridger, MTS/N 18068 N2563ZWien Richard A · Fairbanks, AKBuilt 1963 · S/N 185-0563 N2564GGarrison Jeffrey R · Clemson, SCBuilt 1959 · S/N 51864 N2564RBusse William J · Twin Lakes, WIBuilt 1967 · S/N 18258264 N2564UBurris Bruce · Deer Park, WAS/N 17250164 N2564VMay Matthew J · Weatherford, TXBuilt 1974 · S/N 177RG0617 N2564YBrewer George H · Muskegon, MIBuilt 1962 · S/N 17249864 N2564ZDownwind Aviation LLC · Kodiak, AKBuilt 1963 · S/N 185-0564 N2565CFolgner Robert E · Dana Point, CARegistration revokedBuilt 1954 · S/N 26209 N2565GMoore Timothy L · Wendell, IDBuilt 1959 · S/N 51865 N2565JRohl Bradley S · Thompson, OHBuilt 1965 · S/N 15061065 N2565RSanders David D · Alvin, TXBuilt 1967 · S/N 18258265 N2566CJohnson James K · Sandy Valley, NVBuilt 1954 · S/N 26207 N2566RRastetter Harold · Douglaston, NYBuilt 1967 · S/N 18258266 N2566YAns Aircraft LLC · Midland, TXS/N 17249866 N2567DHaasl Glen D · Chugiak, AKBuilt 1952 · S/N 20719 N2567GSunrise Exploration Inc · Northport, WABuilt 1959 · S/N 51867 N2567KBryant Kenneth D · Black Diamond, WABuilt 1978 · S/N 18052990 N2567RGone Flying LLC · Loveland, OHBuilt 1967 · S/N 18258267 N2567URegistration Pending · Fort Worth, TXRegistration pendingBuilt 1963 · S/N 17250167 N2567VHarness Ben · Covelo, CAFirst renewal noticeBuilt 1976 · S/N R1722223 N2568GKoechen Wayne L · Cooper Landing, AKBuilt 1959 · S/N 51868 N2568ULuce Mark E · Tucson, AZBuilt 1963 · S/N 17250168 N2568VFarringer Steven R · Columbia City, INBuilt 1948 · S/N 18073 N2568XPeasley Casey · Eagle, IDBuilt 1965 · S/N P206-0068 N2569JMapes Peter B · Oscoda, MIS/N 15061069 N2569KHarris Curtis M · Anchorage, AKS/N 18052991 N2569SMatanane Roke C · Barrigada, GUBuilt 1968 · S/N 337-0869 N2569UHalladay Roy · Erie, COBuilt 1963 · S/N 17250169 N2569ZEitilt Aviation LLC · Parker, COBuilt 1963 · S/N 185-0569 N256EPEpic Aviation Inc · New Smyrna Beach, FLBuilt 2025 · S/N 172S13317 N256GPAts One LLC · Mountain View, CABuilt 2002 · S/N 172S9256 N256MEBachelor Joseph Todd · Southside, ALS/N 18280766 N256MWLease Air LLC · Moab, UTBuilt 1977 · S/N 17269958 N256NYAlexander David H · Warrensburg, NYBuilt 1956 · S/N 29049 N256SFAb Prop Plane I LLC · Metairie, LABuilt 2025 · S/N 172S13403 N256SJSan Juan Aviation LLC · Wilmington, DEBuilt 1979 · S/N R1723166 N256TETimberline Excuvation Inc · Fairbanks, AKBuilt 1969 · S/N U2061336 N2570JKnutson Family Ltd Partnership 2 · Chetek, WIBuilt 1964 · S/N 15061070 N2570LHerman John K Jr · Flagler, COBuilt 1967 · S/N 17255770 N2570QGolden Thomas J · Bishop, GAS/N 18257770 N2570RSkyblazers LLC · Boones Mill, VABuilt 1967 · S/N 18258270

Back to AD 79-10-14 R1