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.

N411RFFoothill Aircraft Sales & Service Inc · Upland, CAS/N 17252216 N411SHHartl Stephen J · Live Oak, FLBuilt 1964 · S/N 18051350 N411SSDalmolin Russell Scott · Globe, AZBuilt 1973 · S/N 17261603 N411TABenz Christopher · Seattle, WABuilt 1968 · S/N R172-0196 N411TTRambod Marc · Taos Ski Valley, NMBuilt 1975 · S/N 21060861 N4121FHarrold Bruce E · Greybull, WYBuilt 1958 · S/N 46021 N4121U150d LLC · Attica, NYS/N 15060121 N4124FNelson David R Co-Trustee · New Richmond, WIBuilt 1958 · S/N 46024 N4125FSale Reported · Addison, TXSale reported, pending cancellationBuilt 1958 · S/N 46025 N4125LEvans Samuel F · Selma, ALS/N 17254194 N4125UOxborrow Andrew Charles · Lake Barrington, ILBuilt 1963 · S/N 15060125 N4126FRider Terry · Corinth, MSBuilt 1958 · S/N 46026 N4126LBritton Jeff J · Forest Falls, CABuilt 1966 · S/N 17254195 N4126PPorebski Peter T · New Port Richey, FLBuilt 1975 · S/N 17702320 N4127FDavolt John E · Independence, KSFirst renewal noticeBuilt 1958 · S/N 46027 N4127LHoldt Farms Inc · Elgin, NEBuilt 1966 · S/N 17254196 N4127ULewis Daniel R · Leesburg, INBuilt 1963 · S/N 15060127 N4128FSkidmore Arnold D · Williamsburg, OHBuilt 1958 · S/N 46028 N4129LIrwin Kristin L · Emporia, KSS/N 17254198 N4129ULangen Kenneth · Bozeman, MTBuilt 1963 · S/N 15060129 N4129VStoddart Ranches Inc · Jordan Valley, ORBuilt 1948 · S/N 18461 N412CDOppegard Nicholas D · Eagle River, AKBuilt 1967 · S/N 15067488 N412FBLunken Flight Training Center LLC · Cincinnati, OHBuilt 2017 · S/N 172S12043 N412FRAtp Aircraft 8 LLC · Wilmington, DEBuilt 2014 · S/N 172S11443 N412SPChristiansen Aviation LLC · Wilmington, DEBuilt 1999 · S/N 172S8322 N412SSConnelly James · Spearman, TXBuilt 2022 · S/N 18283196 N412TRoberts Gregory · Scottsdale, AZBuilt 1972 · S/N 21059558 N412WMBroadwell Group Inc · Alpharetta, GABuilt 2012 · S/N 172S11175 N412WSArnold Jerry W · Lincoln, NEBuilt 1970 · S/N 17701475 N41306Bruns Darcy · Sandia, TXBuilt 1969 · S/N 17258310 N4132FBaldwin Vivian E · Owasso, OKBuilt 1958 · S/N 46032 N4133USween Patrick Jv · Spring Valley, MNBuilt 1963 · S/N 15060133 N4133YBlain Gerhart · Billings, MTS/N 18052828 N4134FGaffney Mark M · Lincoln, NEBuilt 1958 · S/N 46034 N4134LMountain View Aviation Inc · Cedar Bluff, VABuilt 1966 · S/N 17254203 N4134VBelgau Robert J · Fort Pierce, FLBuilt 1948 · S/N 18466 N4135LHudson Kimmine · Erie, COBuilt 1966 · S/N 17254204 N4135UBerry Michael D · Bowie, TXS/N 15060135 N4136LDickerson Richard L · Fort Worth, TXBuilt 1966 · S/N 17254205 N4136UChen Adeline B · West Lafayette, INBuilt 1963 · S/N 15060136 N4136VGauntt Chep R · Goodyear, AZBuilt 1948 · S/N 18468 N4137CN4137c Inc · Redwood City, CABuilt 1979 · S/N 21063566 N4137YMurray Robert Scott · Franconia, NHBuilt 1962 · S/N 185-0337 N4138UHaley William R III · Carrollton, GABuilt 1963 · S/N 15060138 N4139UKremer Victor J · Alexandria, MNS/N 15060139 N413AAAmerican Aviation Inc · Brooksville, FLBuilt 2000 · S/N 172S8413 N413CACivil Air Patrol · Maxwell Afb, ALBuilt 2024 · S/N 172S13239 N413CDBecktold Stanley T · Richland, ORBuilt 1962 · S/N 17249689 N413CSGolf Romeo Charlie LLC · Elk Grove, CABuilt 2016 · S/N 18282413 N413EBG&M Aircraft Inc · Wheat Ridge, COBuilt 1979 · S/N 172RG0113

Back to AD 79-10-14 R1