OpenAirDocs.org
AD 79-10-03 R2

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
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.

N5160XCulver Deborah M · Anchorage, AKBuilt 1969 · S/N 166N51614Stillwater Flyers LLC · Columbus, MTBuilt 1981 · S/N 17274330N51616Stardust Aviation LLC · Farmingdale, NYBuilt 1980 · S/N 17274331N5161LGonzalez Ramiro Z · Homeland, CABuilt 1967 · S/N 28-4446N5161MSamora Bobby · Corona, CAFirst renewal noticeBuilt 1978 · S/N M-2039N5161SCapen Leasing LLC · Palm City, FLBuilt 1970 · S/N 28-7105015N5161XSlease Brian D · North Pole, AKS/N 167N51627Warren David T · Mobile, ALS/N 18-8562N5162FLosasso Michaela Marie · Scottsdale, AZBuilt 1979 · S/N 17273120N5162LBlue Gecko LLC · Sheridan, WYBuilt 1967 · S/N 28-4447N5162MCorcoran Thomas A · Braintree, MABuilt 1978 · S/N M-2040N5162PHorton Melody A · Diamondhead, MSBuilt 1958 · S/N 24-178N5162REllis Harvey Airport Inc · Guthrie, OKBuilt 1974 · S/N 17263379N5162SStramer Douglas W · Hazelton, NDBuilt 1970 · S/N 28-7105016N5163DHaddix Stanley D · Hagerhill, KYBuilt 1979 · S/N 17272438N5163LBowyer Richard A · Ormond Beach, FLS/N 28-4448N5163PReynolds David A · Blacksburg, VAS/N 24-179N5163SValley Fliers Flying Club · Auburn, WABuilt 1970 · S/N 28-7105017N5163UValor View Aviation LLC · Midland, TXS/N 172RG0267N5163WSeaton Ryan W · Savannah, TNBuilt 1961 · S/N 28-194N5164EWilliams Kevin J · Giltner, NEBuilt 1978 · S/N 17271746N5164PUpton John B · Lakeland, FLBuilt 1958 · S/N 24-180N5164SNorthern Sky Aviation LLC · Harbor Springs, MIBuilt 1970 · S/N 28-7105018N5164WMorning Aviation LLC · Altoona, PABuilt 1961 · S/N 28-195N5165RAvocado Air LLC · Perkasie, PABuilt 1974 · S/N 17263382N5165SVerte Chad W · Centralia, WABuilt 1970 · S/N 28-7105019N5165WMetro Flyers LLC · Jackson, MSBuilt 1961 · S/N 28-196N5166LEvans Jeffry · League City, TXBuilt 1967 · S/N 28-4451N5166RCrown Flying Club · Overland Park, KSBuilt 1974 · S/N 17263383N51670Colorado Northwestern Community College · Rangely, COBuilt 1980 · S/N 17274336N51675Crawford Aviation Services LLC · Flagstaff, AZBuilt 1968 · S/N 18-8571N5167EJkg LLC · Murfreesboro, TNBuilt 1978 · S/N 17271747N5167HBest Joseph J · Coldwater, MIBuilt 1975 · S/N 17265357N5167MTuggle Casey · Chattanooga, TNS/N M-2043N5167SAngel Carl L · Pikeville, TNBuilt 1970 · S/N 28-7105021N5167WThomas Bobby W Sr · Benson, NCBuilt 1961 · S/N 28-198N51687Ambron Trevor L · Valdosta, GABuilt 1978 · S/N AA5B-0857N5168HBenallo Joseph D · Homer, AKBuilt 1948 · S/N 14-179N5168PCreegan John T Jr · Dundee, ILBuilt 1958 · S/N 24-185N5168WRegistration Pending · Etowah, TNRegistration pendingBuilt 1961 · S/N 28-199N5169LBishop Andre · Greenback, TNBuilt 1967 · S/N 28-4455N5169PStockdale Alexander Ian · Los Banos, CAS/N 24-187N5169SGoddard Julius W Jr · Perry, GABuilt 1970 · S/N 28-7105023N5169VMalcolm Douglas · Shell Beach, CABuilt 1980 · S/N 172RG0458N516AC39 Victor Aviation Inc · Macomb, ILBuilt 2000 · S/N 1294-2000N516AVN388v LLC · Manassas, VABuilt 1981 · S/N 17275205N516DDFawcett Walter L Jr · Wolfeboro, NHBuilt 1981 · S/N 18-8109010N516JTMarcum Brad G · Universal City, TXBuilt 2002 · S/N 21479N516JWAerostar LLC · Newport Beach, CABuilt 1975 · S/N 17265201N516MSSouth Bay Aviation Inc · Torrance, CABuilt 1979 · S/N ME-166
Back to AD 79-10-03 R2