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.

N2652LSullivan James M · East Wakefield, NHBuilt 1967 · S/N 17255852 N2652RDevries Francis P · Justin, TXBuilt 1967 · S/N 18258352 N2652VTrapp Terry Lee Trustee · The Dalles, ORBuilt 1974 · S/N 177RG0644 N2653Barr Air Patrol LLC · Mesquite, TXBuilt 1982 · S/N 18268297 N2653FBagstad Lance · Park Rapids, MNBuilt 1965 · S/N 18256753 N2653GDevine Christopher C · Eagle River, AKBuilt 1959 · S/N 51953 N2653QMoses And Associates Inc · Gainesville, FLBuilt 1966 · S/N 18257853 N2653UClark Nikita C · Ontario, ORS/N 17250253 N2654FGregory Daniel · Virginia Beach, VABuilt 1966 · S/N 18256754 N2654LGriner Carrie L · Auburndale, FLBuilt 1967 · S/N 17255854 N2654RFindarle John J · Midway, UTBuilt 1967 · S/N 18258354 N2654VVankirwin Inc · Kinnelon, NJRegistration expired, pending cancellationBuilt 1974 · S/N 177RG0645 N2654YHolty Joseph G · Fairbanks, AKBuilt 1962 · S/N 18051154 N2655DSutton Aircraft Salvage LLC · Palmer, AKBuilt 1956 · S/N 20807 N2655GBeachy Benjamin D · Whittington, ILBuilt 1959 · S/N 51955 N2655NLetourneau David W · Valencia, CABuilt 1976 · S/N 15077878 N2655QRedmond Angela L · Austin, TXBuilt 1966 · S/N 18257855 N2655RBeck Bartholomew · Dry Ridge, KYBuilt 1967 · S/N 18258355 N2655ZRegistered aircraftN-number assigned (import), not yet registeredS/N 185-0655 N2656GAtp Aircraft 4 LLC · Wilmington, DEBuilt 1998 · S/N 17280569 N2656JSperling Gabriel E · Silverdale, WABuilt 1966 · S/N 15065656 N2656KT And H Aircraft Leasing LLC · Yakutat, AKBuilt 1978 · S/N 18053029 N2656LSzymanski Alexander G · Hernando, MSBuilt 1967 · S/N 17255856 N2656QPankrate Kenneth W · Opheim, MTS/N 18257856 N2656REdex Aviation LLC · Sutter Creek, CAS/N 18258356 N2656SPierini William C · Chico, CABuilt 1976 · S/N 21061346 N2656VMccurdy James Rodney · Statesville, NCS/N 18166 N2657DBouvrie Lukas J · Boulder, COBuilt 1952 · S/N 20809 N2657FPoolshark Equipment LLC · Memphis, TNBuilt 1965 · S/N 18256757 N2657S57 Sierra LLC · Houston, TXBuilt 1968 · S/N 337-0957 N2657USzymanski Janet M · Alanson, MIBuilt 1963 · S/N 17250257 N2657YNagy Leslie S · Walnut Creek, CABuilt 1962 · S/N 18051157 N2658FClayton Alfred T · Anchorage, AKBuilt 1965 · S/N 18256758 N2658GSauer Roger A · Glenburn, NDBuilt 1959 · S/N 51958 N2658JLife Finds A Way LLC · Sarasota, FLBuilt 1966 · S/N 15065658 N2658RNorthern Science Services LLC · Anchorage, AKBuilt 1967 · S/N 18258358 N2658VGriffin Robert L · Warren, OHBuilt 1948 · S/N 18168 N26595Levy Alfred E · Richardson, TXBuilt 1971 · S/N 18260616 N2659GMarmon David J · Great Falls, MTBuilt 1959 · S/N 51959 N2659KWickline Wayne · Flower Mound, TXBuilt 1985 · S/N 18268502 N2659QMorrison Mark C · Marfa, TXBuilt 1966 · S/N 18257859 N2659RBerrios Antonio · Genoa, ILBuilt 1967 · S/N 18258359 N2659SRovey Gerald A · Troy, IDBuilt 1973 · S/N 18502261 N265DTLynn Daniel K · Beaverton, ORBuilt 1975 · S/N 18264034 N265ERAerosolutions Group Inc · Wilmington, DEBuilt 1976 · S/N 17268081 N265HPN265hp LLC · Parachute, COBuilt 1985 · S/N 18268519 N265MESunset Leasing Inc · Sarasota, FLBuilt 2000 · S/N 18280771 N265SFAb Prop Plane I LLC · Metairie, LABuilt 2025 · S/N 172S13409 N2660Applegate Land Holdings LLC · Jacksonville, ORBuilt 1981 · S/N 18268100 N26601Trowbridge Rodney L · Haysville, KSBuilt 1968 · S/N 18259083

Back to AD 79-10-14 R1