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.

N3938QGreen Carl P · Columbia, MSBuilt 1971 · S/N 17260038 N3938RTaylor Joseph Frank · Tamarac, FLBuilt 1966 · S/N 17255438 N3938UNg Charlie K · Oakley, CABuilt 1965 · S/N 15061338 N3939DRed Baron LLC · Middletown, DEBuilt 1957 · S/N 34639 N3939GThree Niner Gulf L L C · Denver, COBuilt 1967 · S/N U206-0939 N3939JMidwest Aero Solutions LLC · Lake Saint Louis, MOBuilt 1966 · S/N 15065239 N3939SDream Big Aviation LLC · Mount Juliet, TNBuilt 1963 · S/N 17251139 N3939VSaddler Joshua L · Lincoln, CABuilt 1975 · S/N 15076660 N393BThickstun Benjamin Tyler · Wasilla, AKBuilt 1973 · S/N 18052299 N393CA2050 Services LLC · Burlington, WIBuilt 2001 · S/N 172S8983 N393DW3 Delta Whiskey LLC · Superior, WIBuilt 1979 · S/N U20605261 N393ESLanier Equipment Leasing LLC · Gainesville, GABuilt 1997 · S/N 17280138 N393MUsda Forest Service Fepp · Helena, MTBuilt 1964 · S/N 185-0684 N393SPCirrus Aviation · Sarasota, FLBuilt 1999 · S/N 172S8290 N3940JJess Lawrence A · Menomonie, WIBuilt 1966 · S/N 15065240 N3940LLeblanc Charles A · Jacksonville, FLS/N 17254109 N3940QN3940q LLC · Newnan, GABuilt 1971 · S/N 17260040 N3940SPrincess Air Inc · Pocahontas, IABuilt 1964 · S/N 17251140 N3940UPage Jeffrey D · Kansas City, MOBuilt 1965 · S/N 15061340 N3940VSoderman Brian · East Bethel, MNBuilt 1975 · S/N 15076661 N3941DOrchid Aero LLC · Lakewood, COBuilt 1957 · S/N 34641 N3941RDemulling Michael C · New Richmond, WIBuilt 1966 · S/N 17255441 N3941VFrazier Jonas · Davie, FLS/N 18260 N39420Shehee Derek J · Prattville, ALS/N R-1720002 N3942FTaylor Brian · Bullhead City, AZBuilt 1958 · S/N 36842 N3942LOriginal Design Ministries · Eatonville, WABuilt 1966 · S/N 17254111 N3942QSullivan Donald Edward II · Edwards, ILBuilt 1971 · S/N 17260042 N3942ROracle Aviation LLC · Omaha, NEBuilt 1966 · S/N 17255442 N3942SCromley Amanda J · Lewisburg, PABuilt 1964 · S/N 17251142 N3942VMossman Andrew D · Pickerington, OHBuilt 1948 · S/N 18261 N3942YBender Andrew J · Greenwood Lake, NYS/N 21058442 N3943Nighthawk N8231g LLC · Pompano Beach, FLBuilt 1984 · S/N 17276186 N3943DLoudan Christopher D · Trinidad, TXBuilt 1957 · S/N 34643 N3943VHardman Kyle B · Shady Shores, TXBuilt 1948 · S/N 18262 N3943YStuart Leslie Trustee · Roseburg, ORBuilt 1964 · S/N 21058443 N3944Avra Valley Flyers LLC · Gilbert, AZBuilt 1964 · S/N 17251510 N3944QFeauto Aviation Inc · Saint Cloud, FLBuilt 1971 · S/N 17260044 N3944RFedorko Stephen J · Springdale, ARBuilt 1966 · S/N 17255444 N3944YBrown Pelican Aviation LLC · Ralston, NEBuilt 1964 · S/N 21058444 N3945DBarnett Lance · Fairfield, CAS/N 34645 N3945LBlakesley Barrett · Spokane, WABuilt 1966 · S/N 17254114 N3945SStrickland Jason R · Tollhouse, CAS/N 17251145 N3946FMatson William J · Wasilla, AKBuilt 1958 · S/N 36846 N3946QSwihart Matthew · Hood River, ORBuilt 1973 · S/N 18502213 N3946SDepoy Lowell K · Salem, INBuilt 1964 · S/N 17251146 N3946YMorris Steven A · Houston, TXBuilt 1964 · S/N 21058446 N3947DBellew James W · Pueblo West, COBuilt 1957 · S/N 34647 N3947FStubbs Scott F · Tucson, AZBuilt 1958 · S/N 36847 N3947RCarter George T · Williamston, SCBuilt 1966 · S/N 17255447 N3947VCooper Charles N III · Sardinia, OHBuilt 1948 · S/N 18266

Back to AD 79-10-14 R1