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.

N5677XKas Properties LLC · Jennings, LABuilt 1993 · S/N E-2797N56780Stewart Donald Kent · Denver, NCBuilt 1973 · S/N 28R-7435041N56782Avie Ation LLC · Suwanee, GABuilt 1973 · S/N 34-7450031N56783Dennerline Rhett R · Northfield, ILBuilt 1973 · S/N 28-7425035N56786Janda Robert J · Grafton, OHBuilt 1973 · S/N 28-7415012N56788Osgood Aaron · Glen Mills, PABuilt 1973 · S/N 28-7405031N5678JOuroboros LLC · Missoula, MTBuilt 2012 · S/N 13328N5678NRedwood Area Flyers LLC · Springfield, MNBuilt 1966 · S/N 0292N5678PWhite John O · Camarillo, CABuilt 1959 · S/N 24-750N5678QPerkins C Trent B · Naubinway, MIBuilt 1965 · S/N 695N5678UPaul William R · Oconomowoc, WIBuilt 1969 · S/N 28-26475N5678WMckinney Douglas Andrew · Hastings, MNBuilt 1963 · S/N 28-913N5678YTaildragger LLC · Glade Spring, VAS/N 18-8317N56790Bradfield Breyson · Mandaree, NDBuilt 1973 · S/N 28R-7435042N56791Brosher Melvin G · Decaturville, TNS/N 28R-7435043N56793Dodson International Parts Inc · Rantoul, KSBuilt 1973 · S/N 32-7400009N56798Warrior Airways LLC · Coral Springs, FLBuilt 1973 · S/N 28-7415013N5679DAce Flight Center Inc · Saint Thomas, VIFirst renewal noticeBuilt 1959 · S/N TD-188N5679JFitzgerald Aviation LLC · Bluffton, SCBuilt 1974 · S/N 18263493N5679KMurphy John Joseph · Mesquite, NVBuilt 1964 · S/N CD-804N5679PKuehnert Stefan · Clarkesville, GABuilt 1959 · S/N 24-751N5679QLambert John D · El Paso, TXBuilt 1965 · S/N 3038N5679SWinters Kevin L · Nine Mile Falls, WABuilt 1966 · S/N MB-122N5679UInverted Holdings LLC · Newnan, GABuilt 1969 · S/N 28-26476N567AAAoa Kissimmee Inc · Kissimmee, FLBuilt 2014 · S/N 172S11418N567ABPiper Aviation LLC · Lewes, DEBuilt 2001 · S/N 0030N567BBBeers Suzanne M · Colorado Springs, COBuilt 1973 · S/N 17701880N567BCDenton James A Trustee · Lompoc, CABuilt 1965 · S/N CD-872N567BHKingsley Kiman J · Miller, MOS/N 32272N567CPCivil Air Patrol · Maxwell Afb, ALS/N 18282167N567DEclipse Inc · Sharon Springs, KSBuilt 1980 · S/N P21000665N567DBGardner Law Firm Pllc · Shawnee, OKBuilt 1965 · S/N 21058689N567DDAir America Flight Center LLC · Daytona Beach, FLBuilt 2005 · S/N 172S9971N567DGFrederick Investment Corp · Raleigh, NCBuilt 1979 · S/N 18266870N567DHDoyel Landy N · Klamath Falls, ORBuilt 1998 · S/N 5152N567DTCenturion Aviation Inc · Kalispell, MTBuilt 1978 · S/N 21062856N567ETMusick Aircraft Corp · Greenwood, MSBuilt 1975 · S/N TC-1866N567FLRidgeline Assets LLC · Wilmington, DEBuilt 2026 · S/N 4496643N567GAAdkins Gordon L · Kenova, WVBuilt 2004 · S/N 3668N567HATj Helicopters LLC · Seymour, TNBuilt 2005 · S/N 10671N567JBenike Ross A · Birchdale, MNBuilt 2002 · S/N 5677N567JBHarper Alli B · Joaquin, TXBuilt 1970 · S/N 18260297N567JL2fly-Safety LLC Trustee · Azle, TXBuilt 1974 · S/N TC-1718N567JWKingdom Power And Glory LLC · Colorado Springs, COBuilt 1999 · S/N 172S8187N567KCWelch Darrnell M · Hillman, MIBuilt 1987 · S/N 4608071N567LUS Department Of The Interior · Boise, IDBuilt 2016 · S/N CC18-0080N567MShower Brenden C · Raleigh, NCBuilt 1979 · S/N CE-854N567MB1 And 3 Lc · Jenks, OKBuilt 2002 · S/N 40052N567MTMiddle Tennessee State University · Murfreesboro, TNBuilt 2003 · S/N 40.308N567NDMoore Aviation Inc · Beaver Falls, PABuilt 2008 · S/N 172S10805
Back to AD 2007-04-19 R1