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.

N257AEBhm Kcak LLC · Akron, OHBuilt 1997 · S/N 18280019 N257CESimonelli Aviation LLC · Fort Myers, FLBuilt 2024 · S/N 18283257 N257CPCivil Air Patrol · Maxwell Afb, ALBuilt 2018 · S/N 172S12133 N257EPEpic Aviation Inc · New Smyrna Beach, FLBuilt 2025 · S/N 172S13332 N257FK257fk LLC · Marathon, FLBuilt 1977 · S/N 17269126 N257JSDelaurentis Robert · San Diego, CABuilt 1978 · S/N 18266090 N257LMSsb Aviation LLC · Wasilla, AKBuilt 1975 · S/N 18052548 N257RRegistered aircraftBuilt 1957 · S/N 34411 N257RAReynolds Darryl G · Wills Point, TXFirst renewal noticeBuilt 1975 · S/N 17266240 N257SPAviatzone LLC · Fort Lauderdale, FLBuilt 1977 · S/N 20700781 N257TATextron Aviation Inc · Wichita, KSS/N 172S13615 N2580DPlace Ashley K · Bradenton, FLBuilt 1952 · S/N 20732 N2580GLei Puahi Inc · Klamath Falls, ORBuilt 1959 · S/N 51880 N2580JKingdom Air Corps · Sutton, AKBuilt 1964 · S/N 15061080 N2580SArizona Production Machinery & Supply · Casa Grande, AZBuilt 1976 · S/N 21061333 N2581CClepper Catherine M · Saegertown, PABuilt 1954 · S/N 26225 N2581DMccullugh Jordon T · Idaho Falls, IDBuilt 1952 · S/N 20733 N2581JStikeleather Fred A · Hiddenite, NCS/N 15061081 N2581KYsc Inc · Harvard, MABuilt 1978 · S/N 18053002 N2581VMink Stephen Earl · Walnut Creek, CABuilt 1974 · S/N 177RG0625 N2581YOverman Aviation LLC · Saint Louis, MOS/N 17249881 N2582DFriesen Gary J · Mariposa, CABuilt 1952 · S/N 20734 N2582KSherman David B · Readfield, MEBuilt 1978 · S/N 18053003 N2582LRichardson Michael Todd · Wilkesboro, NCS/N 17255782 N2582Q82q LLC · Glenwood, MDS/N 18257782 N2582RBergmann Robert A · Lake Placid, FLBuilt 1967 · S/N 18258282 N2582VThul Nathan Michael Trustee · Centralia, IABuilt 1948 · S/N 18087 N2583CWarner Mitchel K · Kodiak, AKS/N 26227 N2583GN2583g LLC · Madison, KSBuilt 1959 · S/N 51883 N2583JLauff Samuel Jr · Ocala, FLBuilt 1964 · S/N 15061083 N2583LMontgomery Robert A · Hampstead, NCBuilt 1967 · S/N 17255783 N2583RHigh Range Aviation Inc · Gooding, IDBuilt 1967 · S/N 18258283 N2583SMackowiak Michael · Haines, AKBuilt 1973 · S/N 18502250 N2583UUfly Vi LLC · St Thomas, VIBuilt 1963 · S/N 17250183 N2583XN2583x LLC · Oklahoma City, OKBuilt 1965 · S/N P206-0083 N2584CMoreman Wiley E · Willcox, AZBuilt 1954 · S/N 26228 N2584JVolar LLC · Forest, MSBuilt 1965 · S/N 15061084 N2584KEichorn Russell A · Grand Rapids, MNBuilt 1978 · S/N 18053005 N2584URedd David C · Blanding, UTBuilt 1963 · S/N 17250184 N2585CGillum Colton M · Ontario, ORBuilt 1954 · S/N 26229 N2585GWilkinson Benjamin M · Anchorage, AKS/N 51885 N2585LAerospace Quality LLC · Piggott, ARS/N 17255785 N2585RChristie Bruce W · Wasilla, AKBuilt 1967 · S/N 18258285 N2585ULionudakis Michael A · Scotts Valley, CABuilt 1963 · S/N 17250185 N2586JHenegar Nathanie L · Owasso, OKFirst renewal noticeBuilt 1964 · S/N 15061086 N2586LRuiz Edinson · Bakersfield, CABuilt 1967 · S/N 17255786 N2586QErrington Aero LLC · Bellefontaine, OHBuilt 1966 · S/N 18257786 N2586SCasey Aviation Inc · Mansfield, MAS/N 17252809 N2586UMaynor Roy · Brazoria, TXS/N 17250186 N2587SFlying Tater LLC · Toms River, NJBuilt 1968 · S/N 337-0887

Back to AD 79-10-14 R1