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.

N32AHLai LLC · Flowood, MSBuilt 1982 · S/N 1268N32AKHummel Karl · Brooklyn, NYBuilt 1973 · S/N 18261935N32BEWisecup Wilbur V Jr · Germantown, OHBuilt 1974 · S/N 17263249N32BHBechtold Brahm Hellman · Parker, COBuilt 1977 · S/N D-10046N32BLHeiser And Associates Inc · Novato, CABuilt 1982 · S/N EA-296N32BZManganaro John G II · Manvel, TXBuilt 1973 · S/N 32-7300014N32CHHeckler Gary C · Carefree, AZBuilt 1966 · S/N 18257332N32CWMcdiarmid Jeffrey · Walla Walla, WABuilt 1977 · S/N 18265680N32CXSkowbo Rock · Jacksonville, FLBuilt 1976 · S/N 7034CN32DARalston Mark D · Roseburg, ORBuilt 1977 · S/N 200N32DBCarpenter Forrest A · Berthoud, COBuilt 1966 · S/N 18051714N32DHHighgate Aero Inc · Swanton, VTBuilt 2004 · S/N 4542004N32DMHulme Thomas L · Fountain Hills, AZBuilt 1959 · S/N 23-1692N32EEMcginnis Patrick J · Friendswood, TXBuilt 1953 · S/N 53-4092N32EJFox Jason Ross · Buckley, WABuilt 1967 · S/N 28R-30287N32EKTips Dan N · Plano, TXBuilt 1963 · S/N 18051264N32ERWolfe Bruce · Fredericksburg, TXBuilt 1978 · S/N AA5B0905N32FCZimin Randolph · South Naknek, AKBuilt 1953 · S/N 30431N32FDMansfield Stephen K · Boynton Beach, FLS/N 20-1249N32FLArmy Aviation Heritage Foundation And Museum · Hampton, GABuilt 1957 · S/N 24020N32FNNoska Frank S IV · Wasilla, AKBuilt 2023 · S/N NOSEXP18-001N32GLG E Air Inc · Broussard, LABuilt 1978 · S/N 3312N32GRAngella Tony · Fort Lauderdale, FLBuilt 2001 · S/N 0046N32GSZeigler Corey M · Harrisville, NYBuilt 1993 · S/N 0016N32GUKerzen Properties LLC · Fayetteville, ARBuilt 2016 · S/N 1N32GVEastern Cincinnati Aviation Inc · Batavia, OHS/N 17267026N32HHagaman John G Trustee · Alexandria, VABuilt 1967 · S/N 1512N32HGGlauser Aviation LLC · Houston, TXBuilt 1958 · S/N 461N32HKInternational Air Services Inc Trustee · Carson City, NVBuilt 2007 · S/N 2431N32HLSmith Elmer A · Rancho Cucamonga, CAS/N 176N32HUMdc Aviation Corp Inc · Amsterdam, NYS/N 1402N32HWStrader John Kelly · Brenham, TXS/N 30-0003N32HYRunzel Brothers Aviation LLC · Bensenville, ILBuilt 2000 · S/N 2102N32JBHeimat Corp · Lincoln, NEBuilt 1971 · S/N 473N32JCMelton Charles Robert · Alexandria, VABuilt 1977 · S/N 24-0120N32JDDuflo Spray Chemical Inc · Bremen, NYS/N 27-372N32JLSanson William P Jr · Dodge Center, MNBuilt 1967 · S/N 28-4391N32JMMiller Biplane LLC · Moberly, MOBuilt 1973 · S/N JM001N32JVChrapczynski Daniel T · Sheffield Village, OHBuilt 1993 · S/N M-II-001N32JWDeach Michael · Lopez Island, WABuilt 2013 · S/N 3367N32KAFowlkes Preston L · Marfa, TXBuilt 2002 · S/N 2193N32KHN32kh LLC · Quincy, WAS/N 287790384N32KTDyson Raymond E · Vero Beach, FLBuilt 2024 · S/N 711N32LDms Aviation Services LLC · Wildwood, MOBuilt 1991 · S/N 654-91N32LACircle S Aviation LLC · Starkville, MSBuilt 1972 · S/N 17260454N32LKMorrow Gregory A · Box Elder, SDBuilt 2007 · S/N 91199N32LLKeys Aviation LLC · Key West, FLBuilt 2021 · S/N 14441N32LPBartlett Paul H · Nebo, NCBuilt 2025 · S/N 18283331N32LSPerhach Andrew J · Seattle, WABuilt 1989 · S/N 1208N32LTLt Leasing LLC · Saint Petersburg, FLBuilt 2021 · S/N 18283154
Back to AD 2007-04-19 R1