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.

N40JCDbs Aviation LLC · Sulphur Springs, TXBuilt 1973 · S/N 421B0384N40JGSimms Charles Jr · Lexington, KYBuilt 1968 · S/N 28R-30953N40JHJohnson Sean M · Martinez, CABuilt 1975 · S/N E-772N40JKMann Nathan · Poulsbo, WABuilt 2022 · S/N 11480N40JMAll Breeds Combined LLC · Kalispell, MTS/N 540-2011N40JSAir Flight Enterprises Inc · South Daytona, FLS/N 24-3269N40JVWhiting Andrew W · Mentor, OHBuilt 1977 · S/N 80N40KGFour Stars Aviation Inc · Mclean, VABuilt 1983 · S/N E-2067N40KHMccormick Robert E · Selah, WABuilt 1979 · S/N 13082N40KLConstantine Lucas L · Inglewood, CAS/N 40.316N40KMFlight Tech LLC · Prosser, WABuilt 2000 · S/N 23063CN40KPZoie Air LLC · Fort Lauderdale, FLBuilt 2003 · S/N 30030CN40KTDemuth Gabriel J · Jackson Springs, NCBuilt 1968 · S/N D-8717N40LSFenhaus Jason · Billings, MTBuilt 1973 · S/N 18262242N40LTNilsson Winston · Merrill, ORBuilt 1953 · S/N 30527N40LYAsh Gary W · Houston, TXBuilt 1978 · S/N 17270900N40MBAndersen Thomas · Yoder, COS/N 708N40MGFly Arkansas LLC · Harrison, ARBuilt 1959 · S/N TD-293N40MMChupp Family Trust LLC · Kalispell, MTBuilt 1964 · S/N TC-740N40MRWennberg Timothy J · Mariposa, CABuilt 1979 · S/N 001N40MUOracle Aviation LLC · Omaha, NEBuilt 1974 · S/N 17264170N40MWCarbone Peter E Jr · Hopkinton, MAFirst renewal noticeBuilt 1980 · S/N E-1708N40NCJones Edward B · Valdese, NCBuilt 1980 · S/N 32-8006014N40NLVetter Brent E · Helena, MTBuilt 1958 · S/N D-5743N40NYJohnson Elite International LLC · Tucson, AZBuilt 1970 · S/N 414-0160N40NZGround Effect LLC · Atascadero, CABuilt 1974 · S/N 32-7440171N40PGFunanich Jon J Trustee · Fairfield, CABuilt 1980 · S/N TJ-309N40PJMitchell Everett · Glendive, MTS/N 3066N40PMFlypie Industries LLC · Hudson, WIBuilt 1986 · S/N 4608005N40PXHealey David A · Hammondsport, NYBuilt 2003 · S/N 14110CN40PZHaagenson Trevor · Portland, ORBuilt 2006 · S/N 155N40RFGamma Flight LLC · Reno, NVBuilt 2007 · S/N 172S10473N40RGDovy Aviation LLC · Houston, TXBuilt 1974 · S/N 17263241N40RSSaul Gregory D Jr · Glenrock, WYBuilt 1960 · S/N 24-2031N40SASemper Fi Aviation LLC · Brooksville, FLS/N 32-111N40SFSterling Flight Training LLC · Jacksonville, FLBuilt 2020 · S/N 2881377N40SKSides Family Management LLC · El Paso, TXBuilt 1979 · S/N 414A0323N40SPSmith Terry G · Liberty Twp, OHBuilt 1980 · S/N 17274099N40SSAdams Aviation Services Inc Trustee · Wilmington, DEBuilt 1979 · S/N 340A0650N40STAvera Stewart · Pensacola, FLBuilt 1997 · S/N T106AN40SYTouchandgo LLC · Hilton Head Island, SCBuilt 1976 · S/N 32R-7680271N40TDWinick Evan K · Allentown, PABuilt 2006 · S/N 1N40TEWild Warbirds LLC · Uvalde, TXS/N CE577N40TMN40tm LLC · Wilmington, DEBuilt 1966 · S/N 1063N40TPDraco Flight School DBA · Chino, CABuilt 1981 · S/N 17274723N40TRKwong Elwood · Foothill Ranch, CABuilt 1977 · S/N E-1190N40TUParrot Cay LLC · Missoula, MTBuilt 1978 · S/N 18-7809143N40VKelly Donald William Jr · Roswell, GABuilt 1971 · S/N TE-799N40VKSimply Living LLC · Fort Myers, FLBuilt 1966 · S/N 24-4473N40VVFaulkner Winthrop S · Anchorage, AKS/N 005
Back to AD 2007-04-19 R1