OpenAirDocs.org
AD 79-10-14 R1

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

N35216Dairy Air Inc · Wyoming, PABuilt 1976 · S/N 177RG1047N35218Chessare Gary M · Caledonia, ILBuilt 1975 · S/N 17702270N35219Nelson Laurel L · Renton, WABuilt 1975 · S/N 17702271N3521JGoldbeck Kenneth J · Moreland, GABuilt 1965 · S/N 15061221N3521KState Of North Carolina · Raleigh, NCBuilt 2002 · S/N 18280998N3521LBiorn Howard L · Brooklyn Center, MNS/N 15062321N3521QCub Club Inc · Fort Myers, FLBuilt 2001 · S/N 172S8847N3521YSportsman Airpark Inc · Newberg, ORS/N 18254421N35220Spoor John B Jr · Sandwich, ILBuilt 1975 · S/N 17702272N35225Nguyen Ricky L · Honolulu, HIS/N 17702275N35229Coneburripul Corp · Miami, FLBuilt 2001 · S/N 172S8837N3522DWaiwood Michael F · Strongsville, OHS/N 27065N3522EKilgore William B · Eureka, CAS/N 17271572N3522JMontgomery Robert L · Port Angeles, WABuilt 1965 · S/N 15061222N3522LTyler Clark D · Fort Wayne, INS/N 15062322N3522QRamirez Jose Marcos · Casa Grande, AZBuilt 1973 · S/N 17261661N3522UDfs · Bountiful, UTBuilt 1963 · S/N 18254922N3522YBohlen Thomas R · Hudson, WIBuilt 1962 · S/N 18254422N35230Christiansen Aviation LLC · Wilmington, DEBuilt 2001 · S/N 17281017N35231Dressler David S · Bend, ORBuilt 1976 · S/N 177RG1048N35238Williams E E · Atlanta, GABuilt 1975 · S/N 17702283N3523CRinio Tyson S · Ester, AKBuilt 1954 · S/N 26566N3523QRed Crest Aviation LLC · Columbus, OHBuilt 1975 · S/N 17702278N3523RAviator Air Flight School LLC · Grand Prairie, TXBuilt 2001 · S/N 17281016N3523UCharlson Aaron H Jr · Forest City, IABuilt 1963 · S/N 18254923N35242Dlss Inc · Caro, MIBuilt 1975 · S/N 17702286N35244Richardson Barry T · Butler, TNBuilt 1975 · S/N 17702288N35246N35246 LLC · Stuart, FLBuilt 2001 · S/N 17281031N35247Dwyer John R · Orange Park, FLBuilt 1975 · S/N 17702289N35249Baker Douglas · Rye, NHBuilt 2001 · S/N 17281030N3524FRegistered aircraftBuilt 2001 · S/N 18280975N3524JRobinson Jimmy T · Cohutta, GABuilt 1965 · S/N 15061224N3524LFlight Training Aircraft LLC · Wilmington, DEBuilt 2001 · S/N 172S8809N3524SFagersten Richard B · Sparta, NJBuilt 1963 · S/N 17250724N3524UHudson George R · Hueytown, ALBuilt 1963 · S/N 18254924N35253Liu Kaiyu · Metairie, LABuilt 2001 · S/N 172S8831N35259Gately Brian P · Brooklyn, NYBuilt 1975 · S/N 17702293N3525CBrann Paul A · West Gardiner, MES/N 26568N3525FR&R Aviation · Gunnison, COBuilt 1966 · S/N 18257525N3525RCrabtree Jeremy Adam · Atlantic Beach, NCS/N 18280977N3525URandolph Macon Academy · Front Royal, VABuilt 2001 · S/N 172S8826N35262Aerial Photos Of New Jersey LLC · Clinton, NJBuilt 1975 · S/N 17702296N35264B&L Aviation LLC · Villa Rica, GABuilt 1975 · S/N 17702297N3526DBrooks Jason M · Eagle River, AKBuilt 1955 · S/N 27069N3526FHaskett Steven E · Austin, TXBuilt 1966 · S/N 18257526N3526JRainier Flight Service LLC · Renton, WAS/N 172S8829N3526LLewis Clinton A · Antlers, OKS/N 15062326N3526SKoenig Edward Executor · Dow, ILBuilt 1963 · S/N 17250726N3526UThomason Tommy Eugene Trustee · Scottsdale, AZBuilt 1963 · S/N 18254926N35273Weltmer Aaron Reece · Rocklin, CABuilt 1975 · S/N 17702303
Back to AD 79-10-14 R1