Registered aircraft · 56,580

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.

N35859Hooper Ranch LLC · Elko, NVBuilt 1975 · S/N U20602763 N3585CRachels Paul R · Tacna, AZBuilt 1955 · S/N 26629 N3585FArikara Properties LLC · Beulah, NDBuilt 1966 · S/N 18257585 N3585QLerner Daniel A · East Durham, NYBuilt 1973 · S/N 17261685 N3585SNorman Jon D · Plainwell, MIBuilt 1963 · S/N 17250785 N3585UNieder Brady W · Anchorage, AKBuilt 1963 · S/N 18254985 N3585YSeemann Brian N · Lake Havasu City, AZBuilt 1963 · S/N 18254485 N35866Terry Kayla · Moulton, ALBuilt 1976 · S/N 177RG1065 N35868Spence Flight Service LLC · Enterprise, ORBuilt 1973 · S/N U20602107 N35869Cardinal Flyers LLC · Moriches, NYBuilt 1976 · S/N 177RG1067 N3586FRegistration Pending · Phoenix, AZRegistration pendingBuilt 1966 · S/N 18257586 N35872Kurtz David Lee · Cordele, GABuilt 1976 · S/N 177RG1068 N35877Turbine Conversions Ltd · Nunica, MIBuilt 1975 · S/N U20602777 N35879Aldrich Brad · Driftwood, TXBuilt 1976 · S/N 177RG1069 N3587FStout Colt W · Bosque Farms, NMBuilt 1966 · S/N 18257587 N3587JJacobson Austin G · Los Alamos, NMBuilt 1965 · S/N 15061287 N3587QBerger Donald D · Ilwaco, WABuilt 1973 · S/N 17261687 N3587SRegistered aircraftAssigned, pending cancellationS/N 17250787 N35883Sasquatch Alaska Adventure Co LLC · Fritz Creek, AKBuilt 1975 · S/N U20602779 N35884Dake Tech Consulting Inc · San Dimas, CAS/N 177RG1070 N35889Torgerson Management Inc · Turtle Lake, WIBuilt 1975 · S/N U20602783 N3588FBlue Eagle Aviation LLC · Edmond, OKS/N 18257588 N3588LVandegrift David H · St Paul, MNBuilt 1965 · S/N 15062388 N3588UBattles Danny C · Burns Flat, OKBuilt 1963 · S/N 18254988 N3589CPalmer Frederick W · Huntington Beach, CABuilt 1954 · S/N 26633 N3589FInmon Glen A · Pontotoc, MSBuilt 1966 · S/N 18257589 N3589LSale Reported · Bloomburg, TXSale reportedBuilt 1965 · S/N 15062389 N3589QHalfpap Rodney J · Quincy, ILBuilt 1973 · S/N 17261689 N3589SErickson Miles · Langley, WABuilt 1963 · S/N 17250789 N3589YHmb Aviation LLC · St George, UTS/N 18254489 N358CBHurn Farm Enterprises LLC · Grand Beach, MIBuilt 2025 · S/N 18283314 N358CPCivil Air Patrol · Maxwell Afb, ALBuilt 2005 · S/N 18281510 N358ESSoutheastern Veterinary Relief Services LLC · Orange Park, FLBuilt 1997 · S/N 17280008 N358KSForgues Inc · Wilmington, DEBuilt 1967 · S/N 15066671 N358MERibelin Holdings LLC · Yacolt, WABuilt 2000 · S/N 18280847 N358TACrow Edward N · Silverdale, WABuilt 1959 · S/N 46666 N358TWTubreaux Aviation Services LLC · Shreveport, LABuilt 2004 · S/N 172S9751 N35905Morgan George Scott · Litchfield Park, AZBuilt 1976 · S/N 177RG1074 N35909Flight1 Hsw LLC · Norwood, COBuilt 1975 · S/N U20602792 N3590CZwingmann Ken · Whittier, CABuilt 1955 · S/N 26634 N3590JLutes Robert Trustee · New Paris, INBuilt 1965 · S/N 15061290 N3590SNorthwest Aircraft Services LLC · Hayden, IDS/N 17250790 N3590YAlexander Macy Nix · Mineral Wells, TXBuilt 1963 · S/N 18254490 N35913Allen John A · Hollister, MOBuilt 1976 · S/N 177RG1076 N35914Dunn Meghan Elizabeth · Mckinney, TXBuilt 1976 · S/N 177RG1077 N3591CSchlender Michael E · Clintonville, WIBuilt 1955 · S/N 26635 N3591FWolfe Robert G · West Columbia, SCBuilt 1970 · S/N 17259225 N3591SPitt Kenneth · Paonia, COBuilt 1963 · S/N 17250791 N3592FArey Peter W · Great Falls, VABuilt 1966 · S/N 18257592 N3592QCentral Arkansas Flying Club Inc · Bryant, ARBuilt 1973 · S/N 17261692

Back to AD 79-10-14 R1