OpenAirDocs.org
AD 79-10-03 R2

Registered aircraft · 40,394

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.

N8543DHuntwork Dayna · Boise, IDBuilt 1957 · S/N 22-5774N8543EAce Aircraft Leasing Inc · Nazareth, PABuilt 1976 · S/N 28-7625140N8544DThames James W · Florence, ALBuilt 1957 · S/N 22-5775N8545DFour-Five-Delta LLC · Mountainville, NYBuilt 1957 · S/N 22-5776N854ACKurchian Aram M · Sunland, CABuilt 1975 · S/N 17265443N854CAJunie The Flying Dog LLC · Atlanta, GABuilt 1973 · S/N 28-7415040N854HCN854hc LLC · Watkinsville, GABuilt 2003 · S/N 5704N854NDAero Equities LLC · Ventura, CABuilt 1989 · S/N 4495008N854PD139th Aeroclub LLC · Miami, FLBuilt 1978 · S/N AA5B-0854N8550DRiester Gary R · Navarre, FLS/N 22-5782N8551VTall Timber Flying Service LLC · Kalispell, MTBuilt 1974 · S/N 793-75N8552DSvec Adolph Ralph · Marengo, ILBuilt 1957 · S/N 22-5784N8554DParks Alan J · Homer, AKBuilt 1957 · S/N 22-5786N8556VParis Charles F · Pioneer, LABuilt 1974 · S/N 794-75N8557DWells Michael D · Wilton, MEBuilt 1957 · S/N 22-5789N8557HLloyd Davis Inc · Brackettville, TXBuilt 1985 · S/N 0460N8558YFritsch Nathaniel · Ettrick, WIBuilt 1968 · S/N 30-1705N8559VHolub Mark A · Dallas, TXBuilt 1974 · S/N 307-75N8559ZMoss Aviation LLC · Howell, NJBuilt 1985 · S/N 0472N855AVD & J Training Planes LLC · Logan, UTBuilt 1978 · S/N 44-7995174N855TSSteier Tim A · Blue Earth, MNBuilt 2005 · S/N 0001N8560DMachovsky Andrew J · Mesa, AZS/N 22-5794N8560MN8560m LLC · Rehoboth Beach, DES/N 0476N8562DKrupinski Floyd M · Chugiak, AKFirst renewal noticeBuilt 1957 · S/N 18-6212N8566VBrown Mill Ranch LLC · Lamar, COBuilt 1974 · S/N 140-75N8567DBelleau Thomas D · Anchorage, AKBuilt 1959 · S/N 18-6785N8567YJohnson Randy D · Becket, MAS/N 30-1715N8569CRudd Wayne G · Basalt, COBuilt 1954 · S/N 18-2720N8569DRegistration Pending · Willow, AKRegistration pendingBuilt 1958 · S/N 18-6223N8569VMachen Paul Stewart · Tallulah, LABuilt 1974 · S/N 795-75N856KWrong Brothers LLC · Sedgwick, KSBuilt 1997 · S/N 9608100N856KWMurphy Michael J · Mendota Heights, MNS/N 188N856NDHillsboro Aero Academy LLC · Hillsboro, ORBuilt 1989 · S/N 4495001N8570CMoos Jacob W · Dillingham, AKBuilt 1953 · S/N 18-2722N8570VJ K Air Inc · Chaffee, NYFirst renewal noticeBuilt 1974 · S/N 308-75N8571VFlywyo LLC · Kalispell, MTBuilt 1974 · S/N 1072-75N8573COcean Aerial Ads Inc · Ocean City, MDBuilt 1953 · S/N 18-2726N8573VSchrack Kevin · Loganton, PABuilt 1974 · S/N 796-75N8574CVan Wagner Aerial Media LLC · Hollywood, FLBuilt 1953 · S/N 18-2728N8575VMcintyre Jon D · Fairbanks, AKBuilt 1975 · S/N 142-75N8576YCenterline Holdings LLC · Belgrade, MTS/N 18-8889N8577Burke Jeremy D · Westminster, COBuilt 1964 · S/N 2737N8577VHoran Spraying LLC · Plainview, TXBuilt 1974 · S/N 309-75N8578CRiver Valley Flyers LLC · West Hartford, CTBuilt 1976 · S/N 28-7690152N8578DCoy Shane A · Nenana, AKBuilt 1958 · S/N 18-6236N8578VNelson Timothy E · Fairbanks, AKBuilt 1974 · S/N 143-75N8579Ralls Eddie · Evergreen, ALBuilt 1973 · S/N 457-73N8579CSolberg John W · Bismarck, NDBuilt 1953 · S/N 18-2732N8579NWillaero LLC · Union City, TNBuilt 1971 · S/N 28-7105133N8579VWalsh Leo A Jr · Anchorage, AKBuilt 1974 · S/N 797-75
Back to AD 79-10-03 R2