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.

N2757FNationwide Web Directory Ltd · Seattle, WABuilt 1965 · S/N 18256857 N2757QFive Seven Quebec Incorporated · Lake Stevens, WABuilt 1967 · S/N 18257957 N2757UUt Lightsport One LLC · Uintah, UTBuilt 1963 · S/N 17250357 N2757VRasnake Larry J · Charlotte, NCBuilt 1975 · S/N 177RG0683 N2758Panair Flying Club Inc · Miami, FLBuilt 1975 · S/N 17265168 N2758JSoutiere Theresa Yvette · Juneau, AKBuilt 1975 · S/N A1500588 N2758SBogner Edward R · Santa Cruz, CABuilt 1967 · S/N 15066658 N2758VRichey Reginald Wade · Lincoln, NMBuilt 1975 · S/N 177RG0684 N2758XAerotechniques LLC · South Kent, CTBuilt 1965 · S/N 18051558 N2759CHillegeist Tracy L · Beverly, KSBuilt 1954 · S/N 26303 N2759JNg Byron · Foster City, CAS/N A1500589 N2759VRedwing Aviation LLC · San Antonio, TXBuilt 1975 · S/N 177RG0685 N275AAAoa Kissimmee Inc · Kissimmee, FLBuilt 2014 · S/N 172S11442 N275DMMaxfield Douglas R · Chico, CABuilt 1975 · S/N 18052558 N275FState Of Alaska Department Of Public Safety · Anchorage, AKS/N U20605207 N275GTPs N275gt LLC · Green Bay, WIBuilt 1978 · S/N 17271631 N275HPRich Aviation Services LLC · Fort Worth, TXBuilt 1976 · S/N 18265173 N275PEPhoenix East Aviation LLC · Daytona Beach, FLBuilt 2007 · S/N 172S10515 N275PTTruss Travis D · Stephenville, TXBuilt 1997 · S/N 18280088 N275TXQualitair LLC Trustee · MichelstadtBuilt 2015 · S/N 172S11635 N275ZZWardell Robert · Montrose AuNon-citizen corporation, flight hours not reportedBuilt 1976 · S/N 18503238 N2760COwens Gary R · Talkeetna, AKBuilt 1954 · S/N 26304 N2760SBond Doyle G · Walker, LABuilt 1967 · S/N 15066660 N2760UAnderson Justin Charles · Rockingham, NCS/N 17250360 N2760VFinish Line - N2760v LLC · Edmond, OKS/N 177RG0686 N2761CLangvardt Rawley J · Elkton, MDBuilt 1954 · S/N 26305 N2761GMartinell Justin E · Dell, MTBuilt 1959 · S/N 52061 N2761JAldrich Curtiss R · Big Oak Flat, CAS/N A1500590 N2761LMiller David L · Mineral City, OHBuilt 1967 · S/N 17255961 N2761UShafer Luke M · Wyoming, ILBuilt 1963 · S/N 17250361 N2762ADorman Richard E · Mesa, WABuilt 1957 · S/N 32849 N2762FFreflite LLC · Wilmington, DEBuilt 1966 · S/N 18256862 N2762LRock Communications · Rock Hill, SCBuilt 1967 · S/N 17255962 N2762UCapozzi Rocky P · Eagle River, AKBuilt 1963 · S/N 17250362 N2763DHammerton David · Olive Branch, MSBuilt 1952 · S/N 25305 N2763FSeawings LLC · Holualoa, HIBuilt 1965 · S/N 18256863 N2763LTrent David A · Davin, WVBuilt 1967 · S/N 17255963 N2763SMoore Park · Byron, GABuilt 1967 · S/N 15066663 N2763UKnutson Wayne R · Tioga, NDBuilt 1963 · S/N 17250363 N2763XThompson Lyndon R · West Fargo, NDBuilt 1965 · S/N 18051563 N2764DHansen Arland R · Warden, WABuilt 1952 · S/N 25306 N2764JMcgregor Daniel A · Denali Park, AKBuilt 1969 · S/N 185-1514 N2764QLong Donald G Jr · Gaston, ORBuilt 1967 · S/N 18257964 N2764SBivens Jason D · Duncan, OKBuilt 1967 · S/N 15066664 N2764UWells Dave · Nampa, IDBuilt 1963 · S/N 17250364 N2765FStoup Lyndal K · Cordell, OKBuilt 1965 · S/N 18256865 N2765XBa Aviation LLC · Anacortes, WAS/N 18051565 N2766DFielding A M Randolph · Jackson, TNS/N 25308 N2766FBrach Raymond S · Henderson, NVBuilt 1966 · S/N 18256866 N2766JBedford Dennis · Auke Bay, AKBuilt 1975 · S/N A1500591

Back to AD 79-10-14 R1