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.

N129DDDruckenbrodt Donald D · Fredericksburg, TXS/N 1393N129DPSplendid Air Leasing LLC · Corpus Christi, TXS/N 310L-0006N129ELTrooien-Smith Construction LLC · Seeley Lake, MTBuilt 1978 · S/N U20604374N129ESWhirlybird Aviation LLC · Naples, IDBuilt 2008 · S/N 12173N129FRWings Over Texas Holdings LLC · Denton, TXBuilt 1981 · S/N 17275338N129GHWoelbing Aviation LLC · Franksville, WIBuilt 1994 · S/N M-1-1775N129GPPafford Holdings LLC · Ruston, LABuilt 2005 · S/N 1366N129GRGunderson Marlon O · Lake Elmo, MNBuilt 2017 · S/N GR01N129HFHeritage Asset Leasing LLC · Ronkonkoma, NYBuilt 2004 · S/N 172S9667N129JAWhite River Holdings LLC · Hernando, MSBuilt 2022 · S/N 18283172N129JPSlezak Douglas C · Atascadero, CAS/N 003N129JTNiles Air LLC · Concord, NCBuilt 2024 · S/N 18283288N129JZThomas James E · Forsyth, GABuilt 2002 · S/N 60321N129KFf22 LLC · Scottsdale, AZBuilt 2022 · S/N 172S12825N129KTFowler Andy D · Anchorage, AKBuilt 1975 · S/N 18502812N129LPJag Aviation LLC · Belle Chasse, LABuilt 1980 · S/N 18504088N129MLarkin Marion J · Salome, AZBuilt 1973 · S/N 18502208N129MAAttwood Nicholas John · Ashburn, VAS/N 2890219N129MFAviation Sciences LLC · Cambridge, MABuilt 1984 · S/N 129N129MSWinging It LLC · Kalispell, MTBuilt 2004 · S/N 3712N129MTMiddle Tennessee State University · Murfreesboro, TNBuilt 2003 · S/N 4496172N129PRRasmussen Paul B · Long Lake, NYBuilt 1968 · S/N 185-1448N129QFlying J Aviation Pllc · League City, TXS/N TC-847N129RJKenney Donill · Lake Worth, FLBuilt 1980 · S/N E-1752N129RVVans Aircraft Inc · Aurora, ORBuilt 2000 · S/N 2N129SAero Quest LLC · Olive Branch, MSBuilt 1974 · S/N 17263118N129SEBarrington Air Inc · Littleton, COBuilt 1998 · S/N 18280384N129SJWorking Capital Group LLC · Rogers, ARBuilt 2001 · S/N 129N129SLLee Aero LLC · Wichita, KSBuilt 1979 · S/N 17273503N129STAzell LLC · Springfield, MOBuilt 1965 · S/N TC-835N129SWRoyal Air LLC · Sarasota, FLBuilt 2018 · S/N 172S12210N129SYDaigle Danny · Greenville, MEBuilt 1978 · S/N 17270741N129TBPeer Thomas A · Tullahoma, TNBuilt 2018 · S/N 82289N129TFGary Boyce Aircrft Sales LLC · Shelbyville, TNBuilt 2026 · S/N 70673N129TRDawson Aircraft Inc · Clinton, ARBuilt 1994 · S/N E-2888N129VRecovery One Services LLC · Georgetown, KYBuilt 1979 · S/N 18267444N129WMSky Solutions LLC · Detroit, MIBuilt 2004 · S/N 10564N129WSNew Horizon Aviation Inc · Warwick, RIBuilt 2005 · S/N 172S10012N129WTHill Tool LLC · Missoula, MTBuilt 2014 · S/N 001N129XSwarts Robert · Cincinnati, OHBuilt 1967 · S/N D-8586N129XCCatbird Cub LLC · Tampa, FLBuilt 2019 · S/N CC19-0047N129YEBuell Travis W · Harper, TXBuilt 2002 · S/N 3334N12ACCarroll Alan R · Mc Farland, WIBuilt 2005 · S/N 80177N12ADAltizer John N · The Woodlands, TXBuilt 1994 · S/N JWA-2N12AKBurk Ross T · Casper, WYS/N 5695N12ALFuller Deidra K · Great Falls, MTBuilt 1981 · S/N DAV-1N12ASNewman Scott W · Healdsburg, CABuilt 1973 · S/N 18502271N12AVChambers Richard A · Sandpoint, IDFirst renewal noticeBuilt 1975 · S/N CE-603N12AWTgam LLC · Toppenish, WABuilt 1978 · S/N U20604688N12BTexacali Air LLC · Salado, TXBuilt 2001 · S/N E-3392
Back to AD 2007-04-19 R1