OpenAirDocs.org
AD 2007-04-19 R1

Registered aircraft · 108,428

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:2007-04-19-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:2007-04-19-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.

N1581JDarling Steven M · Decatur, INS/N 28-23989N15822Keys Daniel A · Irvine, CABuilt 1972 · S/N 28-7325172N15824Sale Reported · Angwin, CASale reportedBuilt 1972 · S/N 28-7305156N15825Jem Machine Inc · Grangeville, IDBuilt 1972 · S/N 28-7305157N1582QWhite William Wayne · Corona, CABuilt 1977 · S/N 18503485N1582WWhite Dove Aviation LLC · Sidney, OHBuilt 1972 · S/N CD-1288N1582XInnovative Aviation LLC · Indiana, PAS/N 28R-7535340N1582ZAugust Aero LLC · Kalispell, MTBuilt 1961 · S/N D-6880N15832Mickschl Bradley J · Avon, INBuilt 1972 · S/N 28R-7335093N15839Phoenix East Aviation LLC · Daytona Beach, FLBuilt 1972 · S/N 34-7350100N1583SSmythe Errol J DBA · Bixby, OKBuilt 1962 · S/N CD-532N1583WNorton William P · Lakeville, MNBuilt 1972 · S/N D-9353N15842Reynolds Larry J · Rhome, TXBuilt 1972 · S/N 28-7325177N1584CHaakenson John R · Sterling, AKBuilt 1953 · S/N 30284N1584EDurbin William E · Parkersburg, IABuilt 1978 · S/N 17271052N1584JLake Kenneth M · Manchester, MOBuilt 1967 · S/N 28-23993N1584SWhitlock Holdings LLC · Honey Grove, TXBuilt 1962 · S/N CD-534N15850Aviation East Inc · Mount Pleasant, SCBuilt 1972 · S/N 28-7305164N15851Eakle Ivan · Sacramento, CABuilt 1972 · S/N 28-7325190N15858T T T Inc · Georgetown, PABuilt 1972 · S/N 28-7325180N1585CHamilton Mark W · Durango, COBuilt 1953 · S/N 30285N1585JAnderson Aviation LLC · Eatonville, WABuilt 1967 · S/N 28-23994N1585ZKnoche Matthew · Clarkston, MIBuilt 1961 · S/N D-6883N15860Baker Stephen J · Surprise, AZBuilt 1972 · S/N 28-7305165N15861Registration Pending · Traverse City, MIRegistration pending, pending cancellationBuilt 1972 · S/N 28-7305167N15862Butler Michael W · Sacramento, CABuilt 1972 · S/N 28R-7335098N15868Mogan & White Inc · New York, NYBuilt 1972 · S/N 28-7325182N1586JLuczak Thomas W · Agoura Hills, CABuilt 1976 · S/N 13016N1586SWits End Travels Ltd · Wilmington, DEBuilt 1962 · S/N CD-535N1586ZJoe L Fisher · Downers Grove, ILBuilt 1961 · S/N D-6882N15871Atlaspar Aviation Group LLC · Lenoir City, TNBuilt 1972 · S/N 28-7305168N15873Miller Robert B · Davenport, FLBuilt 1972 · S/N 28-7305169N15875Cjb Investments22 LLC · Holly Hill, FLBuilt 1972 · S/N 28-7305171N1587MSkywagons.Com LLC · Placerville, CAS/N 18264379N1587SGabay William G · Cocoa, FLBuilt 1962 · S/N TC-322N1587UGrant Aviation Inc · Anchorage, AKS/N 20700187N1587ZGlittenberg Bryson · Flower Mound, TXBuilt 1961 · S/N D-6876N1588Indianhead Aviation LLC · Polk City, IABuilt 1978 · S/N E-1290N15881Ruhnke James · Houston, TXBuilt 1972 · S/N 28-7305173N15882Ellwood David A · Cambridge, OHBuilt 1972 · S/N 28-7305174N15884Fredrickson Ronald C · Woodlake, CABuilt 1972 · S/N 28-7310072N15888Quimbayo Ligia I · Homestead, FLBuilt 1972 · S/N 28-7325189N1588EGeaux Giddum 1 LLC · Brandon, MSBuilt 1978 · S/N 17271054N1588JLampe Mark E · Minnetonka, MNBuilt 1967 · S/N 28-23997N1588MAnderson Aerial Spraying Service Inc · Canby, MNBuilt 1970 · S/N 18800688N1588RRed Earth Trips Inc · Wilmington, DEBuilt 1975 · S/N AA5B-0088N1588SMava Aviation LLC · Fort Worth, TXBuilt 1962 · S/N CD-537N1588VC-140 Company LLC · Milton, FLBuilt 1974 · S/N 17263683N1588XMilligan Reid · Catawba, NCBuilt 1975 · S/N 28-7510087N1588ZWalker Wesley F · Rock Hill, SCBuilt 1961 · S/N CD-436
Back to AD 2007-04-19 R1