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.

N333FVGreco James L · Mount Pleasant, SCBuilt 1976 · S/N AA5A0276N333GKCenturion210 LLC · Amherst, NHBuilt 1976 · S/N 21061282N333GTTriplett Gregory S · Groveland, CAFirst renewal noticeBuilt 1996 · S/N 1333N333HADoran Jeff · Westerville, OHS/N R18200607N333HJSchlender Mike · Clintonville, WIS/N 39-29N333HMVia Vitae Aviation LLC · Lexington, KYBuilt 1981 · S/N 32R-8113096N333HRWilson Alan E Trustee · Erie, COBuilt 1974 · S/N 21060412N333HTTiernan Barton M · Anchorage, AKBuilt 1979 · S/N 33380N333HYFrantz Paul B · Abbeville, GABuilt 1963 · S/N 30-174N333JCHunter Prim LLC · Bolingbroke, GABuilt 1967 · S/N 310L-0197N333JDMountain Mojo Aviation LLC · Banner Elk, NCBuilt 1980 · S/N 27-8054016N333JEJs Aviation Inc · Valparaiso, INBuilt 2026 · S/N 172S13562N333JFWolfe LLC · Rogers, TXBuilt 1963 · S/N 2493N333JGCuthbert Victor W · Dowagiac, MIBuilt 1964 · S/N TD-580N333JMKahl Fredric P · Monmouth, MEBuilt 1972 · S/N M-1404N333JPSpeece Ryan J · Vero Beach, FLBuilt 1967 · S/N D-8539N333JSWarbird Adventures Inc · Ocoee, FLBuilt 1977 · S/N 612-77N333JWPhillips John Patrick · Cumming, GABuilt 1975 · S/N 21061094N333KMParker Michael A · Fowler, INBuilt 1987 · S/N 586N333KNKris Noone Air LLC · Wilmington, DEBuilt 1973 · S/N 17261426N333KRSimmons Anthony T · Easley, SCBuilt 1966 · S/N 1290N333LB333lb LLC · Fort Worth, TXBuilt 1978 · S/N 21062890N333LESky Photoshop LLC · Winter Garden, FLBuilt 2021 · S/N 2666N333LHKoelbl Aviation LLC · Whitesboro, TXBuilt 1981 · S/N 21064220N333LJJarrell Christopher · Lincolnton, NCBuilt 1969 · S/N D-8969N333LSBrown Richard G · Blanchard, OKBuilt 1978 · S/N 17271006N333LTGlover William S · Mount Pleasant, TXBuilt 1981 · S/N 495N333MGherardini Donald A · Sullivan, ILBuilt 2007 · S/N 90439N333MABadolato Leonard · Berlin, NJBuilt 1976 · S/N 28-7615116N333MCGriffin Shawn P · Locust Grove, GABuilt 1964 · S/N TC-660N333MDDunkel Matthew T · Port Orange, FLBuilt 1998 · S/N 070N333MHMerritt Hal S · Hilliard, FLBuilt 2001 · S/N 001N333MMDunlap Rodney L · Jonesboro, ARBuilt 2018 · S/N 40399N333MTGesl Gregg R · New Braunfels, TXBuilt 1968 · S/N 680142N333NPhillipson Justin M · Vacaville, CABuilt 2003 · S/N M-1-2023N333NCCapital Flying Inc · Elk Grove, CABuilt 1968 · S/N 28-5118N333NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2024 · S/N 2881782N333NTKoerner Norman H · Roanoke, TXBuilt 1962 · S/N TD-515N333PGAty Aviation Inc · Watertown, SDBuilt 1977 · S/N 28R-7737114N333PHJ&L Management Group LLC · Lewes, DEFirst renewal noticeBuilt 1993 · S/N 2326N333PJHawaii Pacific Aviation Inc · Kailua Kona, HIBuilt 2005 · S/N 3804N333PKPalmer Joe A · Meridian, IDS/N PK-2N333PLPilot Maker LLC · Hayward, CABuilt 1972 · S/N 18261303N333PSDoran Jeffrey T · Westerville, OHS/N 21060834N333PWTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1980 · S/N 414A0525N333PYMatonti James Robert · Oklahoma City, OKS/N 28-7515380N333QBAdams Chad D · Dayton, ORBuilt 1955 · S/N 31398N333RAShepard Cameron J · Reading, PABuilt 1978 · S/N 3094N333REM I Aviation Inc · Juda, WIBuilt 1980 · S/N E-1737N333RFQualitair Lc Trustee · MichelstadtBuilt 1976 · S/N TJ-92
Back to AD 2007-04-19 R1