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.

N3138URegistered aircraftBuilt 1963 · S/N 18254538N3138WN3138w Bonanza V35b LLC · Jeffersonville, INBuilt 1973 · S/N D-9566N31396Pucciarelli Albert J · Ridgewood, NJBuilt 1978 · S/N 32-7840129N31397Ial Corp · Lewes, DES/N 32R-7885093N31399G&M Aircraft Inc · Wheat Ridge, COBuilt 1978 · S/N 28-7816556N3139DGuichard Lawrence · Spokane, WABuilt 1955 · S/N 31937N3139LOn Premise LLC · Hannibal, MOBuilt 1987 · S/N CE-1143N3139QGrubbs Jerry M · Longview, TXS/N 18258139N3139WGrace Air LLC · Kalispell, MTBuilt 1973 · S/N E-503N313AAAviator Air Operations LLC · Grand Prairie, TXBuilt 2013 · S/N 172S11286N313ACAero Craft Of Bloomington LLC · Bloomington, ILBuilt 1977 · S/N 28-7816013N313AMRademacher John · Cottonwood, AZBuilt 1979 · S/N 28-8011015N313BLDaggett Keith W · Rockport, MEBuilt 1976 · S/N 17267097N313CHSlater Timothy R · Poplar Grove, ILBuilt 1991 · S/N 3017N313CPCivil Air Patrol · Maxwell Afb, ALBuilt 2009 · S/N 18282187N313CWJackson Kimberly L · Show Low, AZBuilt 1996 · S/N 1001N313CZBuckley Robert L Jr · Castle Rock, COBuilt 2009 · S/N 71122N313DDunlap Charles R · Pima, AZBuilt 2013 · S/N 299A-320-61N313DCRegistered aircraftBuilt 1978 · S/N 28-7816591N313DDAlpine Air Aviation LLC · West Haven, UTBuilt 2001 · S/N 3226N313DG3dg Aviation LLC · Louisville, KYBuilt 2005 · S/N 1592N313DQIler Elden · Van Nuys, CAS/N 32533N313EJBohrman Ken C · Pebble Beach, CABuilt 2010 · S/N 40504N313FFerguson John Edward · Santa Ysabel, CABuilt 1958 · S/N D-5764N313GALittle Craig · Oregon City, ORBuilt 2000 · S/N 333AN313GBBurnett Gregory C · Rogersville, MOBuilt 1977 · S/N 21061986N313GMEugene C Warne Trustee · Alamo, CABuilt 2009 · S/N E-3907N313GTRegistered aircraftBuilt 2016 · S/N 92132N313GWWright George E Jr · Homestead, FLBuilt 1956 · S/N 18-5260N313HTKiernan Bernard J · Hopewell Junction, NYS/N 1N313JHJam Three LLC · St George, UTBuilt 1974 · S/N 310Q1011N313JVScholze Jerome V · Anchorage, AKBuilt 2014 · S/N 003N313JWWright George E Jr · Homestead, FLBuilt 1971 · S/N 18260706N313KDOdonnell Daniel Gordon · Plymouth, MABuilt 1975 · S/N 17702353N313LNBazal Jared W · Castle Rock, COS/N 28-2571N313MBosco74 LLC · Wilmington, DEBuilt 1963 · S/N 500A-1276-99N313MAAbrams David · Holmdel, NJBuilt 1998 · S/N 18280238N313MPAlpha Bravo Charlie 1 Corp · Houston, TXBuilt 1980 · S/N P21000573N313MTNguyen Nhu-An T · Parkville, MDBuilt 1977 · S/N 356-77N313MWClover George S · Catheys Valley, CABuilt 1959 · S/N 24-1637N313PSHier Richard T · Lambert, MTBuilt 2002 · S/N 2002-1N313RJNew Hampshire Flying Association Inc · Nashua, NHS/N CE-911N313RTBuechler James K · The Villages, FLBuilt 2012 · S/N 41043N313RVBusbea Shawn · Conway, ARBuilt 2008 · S/N 11366N313RWSarp Rentals LLC · Loudon, TNBuilt 1969 · S/N 414-0010N313SKJohnson Scott · Blaine, MNBuilt 1973 · S/N 18262630N313TAD A Consulting Inc · Orlando, FLBuilt 1977 · S/N AA5A0312N313TDCfi Care Inc · Oxford, CTBuilt 2014 · S/N 72402N313TF313tf Aviation LLC · Superior, WIBuilt 2004 · S/N 1237N313WWilliams Thomas James · Clovis, CABuilt 1981 · S/N D-10363
Back to AD 2007-04-19 R1