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.

N2464UFly By Faith LLC · Laurel Springs, NCBuilt 1963 · S/N 17250064 N2464YHogan Dale R · Monterey, CABuilt 1962 · S/N 17249764 N24658Van Anda Aviation LLC · Apopka, FLS/N 18280660 N2465CToal Timothy R · Milan, ILBuilt 1954 · S/N 30765 N2465ELeal Felipe · Missouri City, TXBuilt 1978 · S/N 17271292 N2465GMunson Darrel L · Ogallala, NEBuilt 1959 · S/N 51765 N2465JWalther Nora P · Ocala, FLBuilt 1966 · S/N 15065565 N2465QChristiansen Aviation LLC · Wilmington, DEBuilt 2005 · S/N 17281271 N2465UProtzair LLC · Aiken, SCBuilt 2005 · S/N 17281272 N2465XK4 Land And Grain Co · Lothair, MTBuilt 1965 · S/N 18256365 N2466EMarkham Dean F Jr · Greenville, NCBuilt 1978 · S/N 17271293 N2466QWentworth Douglas G · Simpsonville, KYBuilt 1966 · S/N 18257666 N2466RToland Beldon T · Dodge City, KSBuilt 1964 · S/N 18255566 N2466TSvetfur Aviation LLC · Camden, SCBuilt 2005 · S/N 172S10062 N2466UHolloway Andrew · David City, NEBuilt 1963 · S/N 17250066 N2466VD & L Aircraft Leasing LLC · Ormond Beach, FLBuilt 2005 · S/N 172S10063 N2466XSpengler Raymond F Jr · Longview, TXBuilt 2005 · S/N 172S10064 N24671Mustang Sally Aviation LLC · Signal Hill, CABuilt 2000 · S/N 17280925 N24673R66 And Cattle LLC · Southlake, TXBuilt 2006 · S/N 18281745 N2467CKsg Capital LLC · Casper, WYBuilt 2000 · S/N 18280789 N2467DKaras Alyssa · Henderson, NVBuilt 1952 · S/N 20619 N2467FTherkelsen Robert D · Burlington, WABuilt 1966 · S/N 18051669 N2467GShort David J · Warrensburg, MOBuilt 1959 · S/N 51767 N2467JHenderson Samuel · Wasilla, AKS/N 15065567 N2467LPatton Michael D · Tygh Valley, ORBuilt 1966 · S/N 17255667 N2467RSparks Eric D · Missouri Valley, IABuilt 1964 · S/N 18255567 N2468BRegistered aircraftBuilt 1970 · S/N 18260274 N2468CHatley Ralph A · Eagle Creek, ORBuilt 1954 · S/N 30768 N2468EUrbany Mark A · Hickory, PABuilt 1978 · S/N 17271294 N2468FSky West Aviation Inc Trustee · Albuquerque, NMBuilt 2000 · S/N 18280780 N2468LCavender Kevin S · Tucson, AZBuilt 1966 · S/N 17255668 N2468RCruson Dale E Trustee · Ontario, ORBuilt 1964 · S/N 18255568 N2468URegistration Pending · Washington, WVRegistration pendingBuilt 1963 · S/N 17250068 N24697Ritton Air Company LLC · Pittsburgh, PABuilt 2005 · S/N 172S10068 N2469DPierce Jerri L · Ozona, TXBuilt 1952 · S/N 20621 N2469MDillehay David Lynn · League City, TXBuilt 1973 · S/N 15075201 N2469QKepler Jason M · Wasilla, AKBuilt 1966 · S/N 18257669 N2469RKrehbiel Doug W · Moscow, IDBuilt 1964 · S/N 18255569 N2469XFraulini Michael M · Franklin Furnace, OHBuilt 1965 · S/N 18256369 N2469YStanphill David L · Stephenville, TXBuilt 1962 · S/N 17249769 N246ARMaravillas Ng LLC · Cupertino, CABuilt 2023 · S/N 18283215 N246BCKeystone Solutions LLC · Higley, AZS/N 18259539 N246BTGentile Keith · Riverton, UTBuilt 1967 · S/N 337-0769 N246CCAlaska Department Of Public Safety · Anchorage, AKBuilt 1979 · S/N U20605314 N246CGDickerson Realty Corp · Charlotte, NCS/N 18281485 N246CPCivil Air Patrol · Maxwell Afb, ALBuilt 2019 · S/N 172S12340 N246ECKnight Air LLC · Wausau, WIS/N 21062435 N246KWGenellie Gerald F Jr Trustee · Batavia, OHBuilt 1980 · S/N 18267659 N246LSJohnson Mark · Macon, MSS/N 32185 N246NSilver Creek Aviation Services · Fort Worth, TXBuilt 2005 · S/N 20608246

Back to AD 79-10-14 R1