Registered aircraft · 40,396

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-03-R2') 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-03-R2') 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-03-R2')
    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-03-R2')
  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-03-R2')
  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-03-R2')
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.

N5115EBarak David T · Mountain Home, IDBuilt 1978 · S/N 17271717 N5115PSmith James Kelly · Newark, OHBuilt 1958 · S/N 24-127 N5115RMichael D Woods LLC · Harleton, TXBuilt 1977 · S/N M-1974 N5115TTurkey Creek Aviation And Helicopter Service LLC · Uvalde, TXBuilt 1966 · S/N 137 N5115UFournier Marc A · Jean, NVBuilt 1994 · S/N 1643 N5115VGruber Thomas · Seattle, WABuilt 1961 · S/N SP-15 N5116HMusgrove Jimmy Wayne · Delta Junction, AKBuilt 1948 · S/N 14-122 N5116JCarll Elizabeth M · Chicago, ILBuilt 1979 · S/N 17273707 N5116LLits LLC · Bowling Green, KYBuilt 1967 · S/N 28-4399 N5116RSajdak Brian Christopher · Hernando, MSBuilt 1979 · S/N M-2164 N5116SWizco Company LLC · Norfolk, NEBuilt 1971 · S/N 28-7105169 N5116VWilliams Harry D III · Frostproof, FLS/N SP-16 N5117EJav Air Services LLC · Anchorage, AKBuilt 1978 · S/N 17271719 N5117LEmery Jonathan D · Payson, AZBuilt 1967 · S/N 28-4400 N5117PMarsteller Michael A · Lugoff, SCBuilt 1959 · S/N 24-130 N5117QBush Thomas D Jr · Cypress, TXS/N 17261755 N5117WJorgensen-Tjorneho Erik R · Conroe, TXBuilt 1961 · S/N 28-142 N5118HDavis John C · Anchorage, AKS/N 14-124 N5119HChenoweth Tucker T · Talkeetna, AKS/N 14-125 N5119PWood John W · Toccoa, GABuilt 1958 · S/N 24-132 N5119WLe Thanh Q · Santa Ana, CABuilt 1961 · S/N 28-144 N511BSMurphy David G · Apalachin, NYBuilt 1978 · S/N 28-7990057 N511DMCapron Robert S · Seneca, SCBuilt 1992 · S/N 10102 N511GKAir Devices Company LLC · Alpena, MIBuilt 1978 · S/N 17270431 N511GLFrerichs Brent A · Sandpoint, IDBuilt 1975 · S/N 0511 N511JHRiester Bernard J Jr · Auburn, NYBuilt 1974 · S/N 652-74 N511JKParcel Stephen · Franklin, NCS/N 60293 N511MGCrock Dominic D · New Concord, OHBuilt 1995 · S/N 2102 N511PTCappe Investment Group LLC · Homestead, FLBuilt 1974 · S/N 17264226 N511RFOlson Dean W · Shelbyville, KYBuilt 1971 · S/N 28-7105167 N5120GGoering Vincent R · Hephzibah, GABuilt 1968 · S/N 28-4937 N5120LClifford Scott P · Wallkill, NYBuilt 1967 · S/N 28-4403 N5120SIntentus Aviation LLC · Sunset, TXBuilt 1971 · S/N 28-7105171 N5120WSeasons Of Life Publications LLC · Greenville, SCBuilt 1961 · S/N 28-145 N51213Shelley Aaron J · Corbin, KYBuilt 1974 · S/N 17264227 N5121GWingsleasing LLC · Wichita, KSBuilt 1968 · S/N 28-5005 N5121HGilsdorf Jason M · Henning, MNBuilt 1947 · S/N 14-127 N5121QClift William R II · Princeton, KYBuilt 1973 · S/N 17261756 N5121SSandmann Ross · Plano, TXBuilt 1971 · S/N 28-7105175 N5121WCarroll Thomas F · Independence, MOBuilt 1961 · S/N 28-146 N51221Provost Kevin H · North Swanzey, NHS/N 17264228 N51222Mbk Leasing And Consulting LLC · Lakeland, FLBuilt 1980 · S/N 17274283 N5122LJuliet Sierra Foxtrot LLC · Denver City, TXBuilt 1967 · S/N 28-4405 N5122R1st Clev-Mar LLC · Lakeview, ARBuilt 1974 · S/N 17263340 N5122SKudla Frank R · Bean Station, TNBuilt 1971 · S/N 28-7105172 N5122WSale Reported · Cape Elizabeth, MESale reportedBuilt 1961 · S/N 28-148 N51236Christiansen Aviation LLC · Wilmington, DEBuilt 1981 · S/N 17274286 N51238Flying G Aviation Inc · Drayton, NDBuilt 1980 · S/N 17274287 N5123EMiller Kenneth Allen · Riverhead, NYBuilt 1978 · S/N 17271722 N5123JCircle W Flying Club Inc · Creighton, PABuilt 1979 · S/N 17273709

Back to AD 79-10-03 R2