AD 49-50-01

Registered aircraft · 9,191

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:49-50-01')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:49-50-01')
  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.

N10534Shergi Nikolai W · Franklin, INS/N 15697N1054FGilson Gareth F · Phoenix, AZS/N 15AC-68N1055HReddell Justin · Jasper, ARBuilt 1948 · S/N 15AC-70N1057NMiller Richard L · Erie, COBuilt 1982 · S/N 122N1059EDeaero LLC · Darwin, MNS/N 7AC-4610N1060HJohnston Jeffery A · Eagle River, AKBuilt 1948 · S/N 15AC-76N1064KStein Andrew · Modesto, CABuilt 1946 · S/N 3791N1067HAmerell Kathryn · Wasilla, AKS/N 15AC-86N106FBZimmerman Frederick J · Boulder City, NVBuilt 2010 · S/N 001N1070HGeary Charles L · Wasilla, AKBuilt 1948 · S/N 15AC-89N1071HBeck Douglas J · Bloomington, MNBuilt 1948 · S/N 15AC-90N1072HBeckman Thomas J · Pocahontas, ARBuilt 1948 · S/N 15AC-91N1075HBartholomew Dana C · Madison, WIBuilt 1948 · S/N 15AC-94N1077HHadley Everett F · Dayville, CTBuilt 1948 · S/N 15AC-96N10785Burton Robert E Jr · Vancouver, WABuilt 2024 · S/N 85N1078KClairday Preston H · Melbourne, ARS/N 3805N1083HHead Wesley J · Homer, AKBuilt 1948 · S/N 15AC-102N10866Mcglothlen Mike C · Muscatine, IABuilt 1975 · S/N JE-2N1088ESmith Mark E · Lakeville, NYS/N 7AC-4641N1088HAerotechniques LLC · South Kent, CTBuilt 1948 · S/N 15AC-52N108RHBashaw Nathan R · Salem, NYBuilt 1940 · S/N 5958N1091HHuber Gregory A · Medina, OHFirst renewal noticeBuilt 1948 · S/N 15AC-112N10967Weeks Kermit A · Polk City, FLBuilt 1931 · S/N 1145N1096EMarrs David R DBA · Bella Vista, ARBuilt 1946 · S/N 7AC-4649N1096HRegistration Pending · Wasilla, AKRegistration pendingBuilt 1948 · S/N 15AC-116N1097HPoulter Thomas R · Chelsea, MIBuilt 1948 · S/N 15AC-117N10982Burris Kye A · Gillett, ARBuilt 1972 · S/N 41-72N10996Coughlin Edward L · Cazenovia, NYBuilt 2011 · S/N 1N1099HTzenis Michael · Lakeville, MNBuilt 1948 · S/N 15AC-119N109SCCobb Lee C · Van Alstyne, TXBuilt 1951 · S/N 51-15307N10ANSouth Dakota Hist Avn Preservation & Educ Soc Inc · Canistota, SDBuilt 1947 · S/N 7BCM-445N10KSMorris Jerry M · Summerville, SCBuilt 1946 · S/N 388N10MJHocker James L · Brookville, OHBuilt 1988 · S/N 1104N10XSWittman Flying Service · Ripon, WIBuilt 1946 · S/N 22366N11018Jepsen Dorian B · Selah, WABuilt 1965 · S/N T-5423N1103Schmidt Thomas P · Nunica, MIBuilt 1958 · S/N 7FC-234N1103DOber John A · Candor, NYBuilt 1950 · S/N 15663N1104DRymill Mark R · Belmont, CABuilt 1950 · S/N 15664N1105DGilman Larry E · Reno, NVBuilt 1950 · S/N 15665N1105HMaya Aviation LLC · Lee, NHBuilt 1948 · S/N 15AC-125N1106DMurdock Mark F · Ketchikan, AKBuilt 1950 · S/N 15666N1106TPierce John R · Hulett, WYBuilt 1949 · S/N 11-996N1109BWeymouth James H · Jackson, MIBuilt 1947 · S/N 5736N1109DMcqueen Alan G · Cocoa, FLFirst renewal noticeBuilt 1950 · S/N 15669N1109WOrton Aviation LLC · Walker, MNBuilt 1957 · S/N 18-5946N110QSilvaire Air LLC · Gun Barrel City, TXBuilt 1948 · S/N 5983N110RHHardin Donald D Trustee · Kirkwood, MOBuilt 1999 · S/N 766N110RRGalloway Landings LLC · Caledonia, MIBuilt 1946 · S/N 19659N110SLaysoncraft LLC · Clarkston, MIBuilt 1960 · S/N S-79N110XPlayter Bud W DBA · Gowen, MIFirst renewal noticeBuilt 1946 · S/N 10449
Back to AD 49-50-01