OpenAirDocs.org
AD 2007-04-19 R1

Registered aircraft · 108,433

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.

N22TFBettendorf Elizabeth J · Salem, ORBuilt 1973 · S/N 1186N22TGChin-Loy Christopher Waynetrustee · Tamarac, FLBuilt 1977 · S/N 21061904N22TJFerraro Thomas P · Mckinney, TXBuilt 1978 · S/N 0047N22TNNewman William L · Breckenridge, TXBuilt 1965 · S/N D-8032N22TYCygnus9 LLC · Fayetteville, NCBuilt 1997 · S/N TH-1826N22UTMomentum Foundation · Tullahoma, TNBuilt 1981 · S/N 32-8106067N22VBCooper Tom · Keavy, KYBuilt 1994 · S/N 1050N22VCVictorcharlie LLC · Weston, MABuilt 2005 · S/N 1341N22VFAir Conejos LLC · El Paso, TXBuilt 1978 · S/N P21000106N22VXDo Good Things LLC · Port Orange, FLBuilt 1978 · S/N TJ-171N22WDEhrler Ryan R · Spokane, WABuilt 1967 · S/N 680110N22WGCorpat Inc · Missoula, MTBuilt 1981 · S/N P21000733N22WJJabour William J · Port Orange, FLBuilt 2011 · S/N 73604N22WLSchauer Henry A · Fort Collins, COBuilt 1966 · S/N CE-41N22WPMatulich Ronald G · Drytown, CABuilt 1967 · S/N TC-1045N22WSJ M Mcleod Farms LLC · Carthage, NCBuilt 1979 · S/N E-1506N22WWMouse Air LLC · Hilton Head Island, SCBuilt 1969 · S/N 28-5420N22WXCisneros Corina · Belmont, NHBuilt 2002 · S/N 0281N22WZStevens John W · Anacortes, WABuilt 2010 · S/N 001N22XDNokes James · Woodbury, TNBuilt 2003 · S/N 0531N22XGPixton Thomas J · Incline Village, NVBuilt 1966 · S/N D-8369N22XKGonzales Michael R · Lancaster, CABuilt 1998 · S/N 23015N22XRKabil Flyers Inc · Vestal, NYBuilt 2013 · S/N 025N22XSSuell Tommy R · North Las Vegas, NVBuilt 1998 · S/N CM-001N22YLowe David M · Sacramento, KYS/N TN-9N22YYArjad Henry · Irvine, CABuilt 2003 · S/N L2K-144N22ZECoats James Michael · Murrieta, CABuilt 1999 · S/N 0026N22ZHBrookway Aviation LLC · Brookhaven, MSBuilt 1999 · S/N 2047N22ZV2 Blondes On Board LLC · Brenham, TXBuilt 1979 · S/N E-1570N22ZZTreicher Peter · East Aurora, NYFirst renewal noticeBuilt 1979 · S/N 27-7954043N2300BGoodox LLC · Garden Plain, KSBuilt 1948 · S/N 3600N2300CWasp Air LLC · Hamilton, MTBuilt 1953 · S/N 30600N2300HN112vg LLC · Princeton, NJBuilt 1991 · S/N 1842N2300JRadosevich Michael K · Albuquerque, NMBuilt 1963 · S/N M-246N2300LAv8n Idaho LLC · Greenleaf, IDBuilt 1962 · S/N M-112N2301BKing Larry Joe · Quanah, TXBuilt 1948 · S/N 3601N2301LMuskrat Flying Club LLC · Orlando, FLBuilt 1963 · S/N M-122N2301PWheatley David L · Saltsburg, PABuilt 1955 · S/N 22-2711N2301TMarks Aviation LLC · Isle Of Palms, SCBuilt 1971 · S/N 28-7125545N2301XPetritsch Ryan · Warrington, PABuilt 1965 · S/N 18256201N2301ZRegistration Pending · Maumee, OHRegistration pendingBuilt 1962 · S/N M-4N2302ADutchess Community College · Poughkeepsie, NYBuilt 1991 · S/N 1903N2302CDuck & Goose Aviation Inc · St Simons Island, GABuilt 1997 · S/N E-3102N2302GDolce Aviation LLC · Hamilton, MTBuilt 1958 · S/N 51602N2302JGo Fly Maui LLC · Paia, HIBuilt 1946 · S/N 1946N2302RNitz Michael W · Volente, TXBuilt 1964 · S/N 18255402N2302XSedation Vacation Pllc · Dalton, GABuilt 1965 · S/N 18256202N2302YMustang Sally Aviation LLC · Camden, SCBuilt 2005 · S/N 172S9973N2302ZJohnson Melvin L · Toney, ALBuilt 1962 · S/N M-5N2303QVan Hoosen Ronald L · Goldsby, OKBuilt 1963 · S/N M-369
Back to AD 2007-04-19 R1