OpenAirDocs.org
AD 50-12-01

Registered aircraft · 1,076

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:50-12-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:50-12-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.

N1004Glover William S · Mount Pleasant, TXBuilt 1928 · S/N 416N1006DObrian Laurence J · Northridge, CAS/N 7614N10218Porter Wade R · Chico, CABuilt 1959 · S/N 18N10250Adcock Colton L · Dustin, OKBuilt 1960 · S/N 50N10256Triple F Flying Inc · Benton, PAS/N 56N1028CCourtney Brent C · Magnolia, TXBuilt 1941 · S/N 75-2051N10294Miller Andy · Marana, AZS/N 94N1042MDusters And Sprayers Supply Inc · Chickasha, OKS/N 75-7136N1044DMcadam Charles T · Wichita, KSBuilt 1951 · S/N 7656N1046MStoos Robert A · Lakeland, FLBuilt 1943 · S/N 75-7204N10471Dyson Keith A · Port Townsend, WABuilt 1929 · S/N 2N1048MMccullough Carol Charlene Trustee · Tulsa, OKBuilt 1942 · S/N 75-6669N104HAir Cav Helicopters LLC · Wilmington, DES/N 75-2820N1058DMorley Philip · Manhattan Beach, CABuilt 1951 · S/N 7670N1066MN1066m LLC · Vero Beach, FLBuilt 1942 · S/N 75-7932N1068NTravis Brent N · Hayden Lake, IDBuilt 1943 · S/N 75-5364N107PRDownwind Flight LLC · San Antonio, TXBuilt 1941 · S/N 75-829N1080DLindsey Paul Robert · Quinlan, TXBuilt 1951 · S/N 7692N10QHammerle Tye F · Kenosha, WIBuilt 1940 · S/N 75-301N11247Elliott John David · Bethesda, MDS/N 3487N11253Patterson John Miles II · Frankfort, KYBuilt 1931 · S/N 3212N11274Vintage Aero Inc · Duncan, OKBuilt 1933 · S/N 3690N11427Murray Thomas J · South Hampton, NHBuilt 1931 · S/N 3488N11440Aerojet Services Inc · Aurora, COS/N 3497N11453Callis Aviation LLC · Roanoke, VABuilt 1931 · S/N 3539N11468Maples Charles S · Fairfax, VAS/N 3541N11470Lovley Forrest T · Jordan, MNBuilt 1931 · S/N 3513N11478Taylor Daniel J · Dandridge, TNBuilt 1932 · S/N 3559N11480Slocum James E · Poplar Grove, ILBuilt 1931 · S/N 3556N11490Pietsch Warren A · Minot, NDBuilt 1931 · S/N 3572N117RVAero Rents Inc · Germantown, TNS/N 75-7232N11XSink Lendon V · Lexington, NCBuilt 1941 · S/N 1418N1203MHeritage Aviation LLC · Shannon, ILBuilt 1943 · S/N 75-8167N120SRRed Baron LLC · Middletown, DES/N 1221LMN12237Mone Brent C · Santa Rosa, CABuilt 1936 · S/N 3N12374Swindle Don K · Collinsville, TXBuilt 2006 · S/N 3764N12428Flying Barefoot Ranch LLC · Wilmington, DEBuilt 1940 · S/N 3569N12438Sale Reported · Groveland, CASale reportedBuilt 1932 · S/N 3579N12443Steeves Brian · Wahpeton, NDBuilt 1932 · S/N 3606N1244GFlyboy LLC · Tampa, FLBuilt 1932 · S/N 3607N124BHMccusker Marina · Stuart, FLS/N 75-7606N12557Collins Roger D · Woodinville, WABuilt 1941 · S/N 75-2625N129LOld Goat LLC · Wilmington, DEBuilt 1943 · S/N 75-8581N12FRWeston David · Burke, VAS/N 75-4581N13027Western Antique Aeroplane & Automobile Museum · Hood River, ORBuilt 1932 · S/N 3660N13050Plane Fun Inc Tr Trustee · Snellville, GABuilt 1932 · S/N 3678N13071Period Aviation LLC · Babylon, NYBuilt 1933 · S/N 3689N13072Bonafide Investments LLC · Dover, DEBuilt 1933 · S/N 3724N1307NWeir Ryan L · Buckley, WAS/N 75-5135N130PTMount Glenn W · Modesto, CABuilt 1942 · S/N 325H0
Back to AD 50-12-01