AD 2007-04-19 R1

Registered aircraft · 108,434

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.

N31VXGordon Charles M Trustee · Haymarket, VABuilt 2018 · S/N 00182N31WBBaker James P · Brighton, COBuilt 1995 · S/N 22470N31WFTaylor Peter L · Beaumont, TXBuilt 1999 · S/N 1461N31WGFleischman James H · Remus, MIBuilt 1990 · S/N 1951N31WKKing Wesley A · Los Angeles, CABuilt 1995 · S/N 1060N31WLAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2003 · S/N 0679N31WM3 Point Aviation LLC · Claremont, NHBuilt 2018 · S/N CC19-0027N31WTThomas Norman W · Forest, VABuilt 1980 · S/N 172RG0291N31WYBellamy Mark A · Freeville, NYBuilt 2010 · S/N 3108N31XEverson Dustin J · Providence, RIBuilt 1992 · S/N 671-92N31YBritton Stephen D · Delhi, LABuilt 1957 · S/N TD-41N31YBProgressive Air Inc · Janesville, WIBuilt 1979 · S/N 18266786N31YFCharliefoxtrot LLC · Farmington, MOBuilt 2015 · S/N 1158-2015N31YKJendair LLC · New York, NYBuilt 1973 · S/N 310Q0934N31ZRRusso R Michael · Pipersville, PABuilt 2004 · S/N 23093N32003Gem Aviation Corp · Sugar Land, TXBuilt 1974 · S/N 28-7515043N32004Priceless Pleasures LLC · Jordan, MNBuilt 1974 · S/N 28-7515044N32008K L M Aircraft Co · Media, PABuilt 1974 · S/N 28-7505014N3200ERegistration Pending · Burlington, WIRegistration pendingBuilt 1978 · S/N 17271466N3200GSpinner Family Limited Partnership · White City, ORBuilt 1956 · S/N 22-4042N3200LRapid Imaging Solutions LLC · American Fork, UTBuilt 1965 · S/N 310J0200N3200MPride Jesse D · Eagle River, AKS/N 12-1872N3200NLazy Bones LLC · Mitchell, SDBuilt 1998 · S/N E-3200N3200RTexeira David A · Venice, FLBuilt 1969 · S/N 28R-31126N3200SGreene James · Georgetown, TXBuilt 1964 · S/N 18255700N3200UAnderson & Assoc Attorneys At Law Pc · Virginia Beach, VABuilt 1962 · S/N 18254600N3200WBrickley Brian J · Manchester, MIBuilt 1964 · S/N 32-04N3200YCondo Gerardo B · Miami, FLBuilt 1962 · S/N 18254200N3200ZBrady Michael E · Buffalo, NYBuilt 1959 · S/N 22-7140N32019Spicher Samuel Charles · Harrisonburg, VABuilt 1974 · S/N 28-7505017N3201DMelnick Victor D · Mount Bethel, PABuilt 1955 · S/N 31999N3201GArdent Aviation LLC · Salt Lake City, UTBuilt 1978 · S/N 24-0565N3201LFowler Scott A · Lakeland, FLBuilt 1978 · S/N 24-0566N3201SBoder Eric T · Knoxville, TNBuilt 1964 · S/N 18255701N3201ZMcclain William J · Corona, CABuilt 1959 · S/N 22-7141N32020N32020 LLC · Springfield, MOBuilt 1974 · S/N 28R-7535015N32025Biafora Joseph R Jr · Panorama City, CABuilt 1974 · S/N 28-7510008N3202CJohnson Jeremiah · Fairbanks, AKS/N 18262345N3202SCramer Traci · Hatfield, PABuilt 1996 · S/N 1111SN32030Robert Starr · Schofield, WIBuilt 1974 · S/N 28-7515048N3203FChampagne Anthony J · Prairieville, LABuilt 1967 · S/N 670123N3203GAlpine Air Alaska LLC · Girdwood, AKBuilt 2007 · S/N 11586N3203MDavid Dorin A · Kasilof, AKBuilt 1947 · S/N 12-1873N3203UKuykendall Kirk O · Lakeside, ORS/N 18254603N32042Van Anda Aviation LLC · Apopka, FLBuilt 1974 · S/N 28-7515052N32043Brolan Aviation LLC · Kansas City, MOBuilt 1974 · S/N 28-7515053N32047Sat Aircraft LLC · Clermont, FLBuilt 1974 · S/N 28R-7535018N3204DGriffith Sherman · Southlake, TXBuilt 1955 · S/N 32002N3204UBlue Sky Flyers Inc · Punta Gorda, FLBuilt 1962 · S/N 18254604N32052Risley Bryan D · Bartow, FLBuilt 1974 · S/N 28-7525016
Back to AD 2007-04-19 R1