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.

N2587UEt Flight LLC · Cedar Park, TXBuilt 1963 · S/N 17250187 N2588JShannon Noah Chad · Lawrenceburg, TNBuilt 1964 · S/N 15061088 N2588RPoplin Tristan · Frisco, TXBuilt 1967 · S/N 18258288 N2588ZBindon Philip E · Wasilla, AKBuilt 1963 · S/N 185-0588 N2589GPreisse Gene L Jr · Akron, OHBuilt 1959 · S/N 51889 N2589QMolek Eugene · Warren, OHS/N 18257789 N2589VGraveson John W · Uxbridge, MABuilt 1948 · S/N 18094 N2589YOrtner Airport LLC · Wakeman, OHBuilt 1962 · S/N 17249889 N258BWEastern Kentucky University · Richmond, KYBuilt 1981 · S/N 17274811 N258EPEpic Aviation Inc · New Smyrna Beach, FLBuilt 2025 · S/N 172S13334 N258ERLewis Carlos Brandon · Indian Mound, TNBuilt 1978 · S/N 17270891 N258KCBredesen Benjamin C · Nashville, TNBuilt 1978 · S/N 177RG1304 N258MAJ Linn Aviation Inc · Quinlan, TXS/N 17269926 N258MEGolf Delta Charlie LLC · Baton Rouge, LABuilt 2000 · S/N 18280768 N258RAReynolds Darryl G · Wills Point, TXBuilt 1978 · S/N 17270533 N259Clark Jack E Jr · Mesa, AZFirst renewal noticeBuilt 1975 · S/N P337-0220 N2590DJenkins Richard E · Grants Pass, ORBuilt 1952 · S/N 20742 N2590KHilltop Aviation Group LLC · Jay, MEBuilt 1978 · S/N 18053006 N2590RMason John A · Scottsdale, AZBuilt 1967 · S/N 18258290 N2591DRootvik Dennis L · College Place, WAS/N 20743 N2591JNagel Larry A · Hurricane, UTBuilt 1965 · S/N 15061091 N2591LHettenbach Paul A · Carrollton, TXBuilt 1967 · S/N 17255791 N2591QDeadmond Matthew J · Princeton, CABuilt 1966 · S/N 18257791 N2591TFerguson John W · Edwardsburg, MIBuilt 1975 · S/N U20602594 N2591VLivewire Holdings LLC · Salinas, CABuilt 1974 · S/N 177RG0627 N2592DSweet Warner Sr · Wakefield, RIBuilt 1952 · S/N 20744 N2592GLeft Heading LLC · Herriman, UTBuilt 1959 · S/N 51892 N2592JParker Alan K · Lenoir, NCBuilt 1964 · S/N 15061092 N2592XLorraines Blue Sky Aviation LLC · Norman, OKBuilt 1965 · S/N P206-0092 N2593GIntelinair Geospatial LLC · Indianapolis, INBuilt 1958 · S/N 51893 N2593LDaly Moses M · Underhill, VTBuilt 1967 · S/N 17255793 N2593QRigoni Teresa Ann · Orting, WABuilt 1966 · S/N 18257793 N2593UCamara Cesar David · Plumas Lake, CABuilt 1963 · S/N 17250193 N2593VKenyon Chad J · Sterling, AKBuilt 1948 · S/N 18098 N2594DSwift John P · Enfield, CTBuilt 1952 · S/N 20746 N2594LSheldon Paul T · Saint James, MNBuilt 1967 · S/N 17255794 N2594QBarer Scott I · Westlake Village, CABuilt 1966 · S/N 18257794 N2594YBruns John R Jr Trustee · Floyds Knobs, INBuilt 1963 · S/N 17249894 N2595LPiper Capital Growth Fund LLC · Scottsdale, AZBuilt 1967 · S/N 17255795 N2595RDierenfeld Michael E · Northwood, IABuilt 1967 · S/N 18258295 N2595UHare Sidney Wiggins · Roanoke, ALBuilt 1963 · S/N 17250195 N2595VJm Aviation LLC · Howe, INS/N 18100 N2595YRenco Angelo · Oceanside, CAFirst renewal noticeBuilt 1962 · S/N 17249895 N2596GThomas Carlton L · Center, COBuilt 1959 · S/N 51896 N2596KPopov Chris · Hope, IDS/N 18504257 N2596LBurris Cale · Hardin, ILBuilt 1967 · S/N 17255796 N2596QEvening Star Aviation LLC · Corvallis, ORFirst renewal noticeS/N 18257796 N2596RJones Jacob R · Rockford, TNBuilt 1967 · S/N 18258296 N2596XCarter Jason J · Athena, ORBuilt 1965 · S/N P206-0096 N2597CWintersteller Oliver · Brighton, MIBuilt 1954 · S/N 26241

Back to AD 79-10-14 R1