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.

N225FTSerrino Sam · Youngstown, OHBuilt 2001 · S/N 3231N225GAKeh Enterprises LLC · Helena, MTS/N 225N225GSAdams Aviation Services Inc Trustee · Wilmington, DEBuilt 2025 · S/N 14865N225JAirtime LLC · Dayton, IDBuilt 2013 · S/N TC0611004N225JACoffin Paul · Sioux City, IABuilt 1979 · S/N R18201320N225JBBearden James T · Rolla, MOBuilt 2018 · S/N 63017N225JWTalbot Larry · Lakewood Ranch, FLBuilt 2001 · S/N E-3418N225KLMeridian Aircraft LLC · Wilmington, DEBuilt 2022 · S/N 2881534N225KMD&L Leasing Montana LLC · Kalispell, MTBuilt 2020 · S/N TH-2536N225KYAtb Inc Trustee · Wilmington, DEBuilt 2004 · S/N 3691N225LRice James M · Austin, TXBuilt 1965 · S/N 310J-0025N225MGandiaga Philip John · Buhl, IDBuilt 1960 · S/N 52996N225MHMissall Zoe S · Ontario, NYBuilt 1974 · S/N 17263156N225MLSeaton Flying Services · Killeen, TXBuilt 2007 · S/N 1810N225NTLattin Travis W · Beloit, KSBuilt 2024 · S/N 225N225PSalem Aviation LLC · Winston Salem, NCBuilt 1997 · S/N EA-608N225QZHoward Alan L · Leeds, UTBuilt 1969 · S/N 138N225R707 Aviation LLC · Batesville, MSBuilt 1974 · S/N TC1728N225RARochester Air Center LLC · Canandaigua, NYBuilt 2005 · S/N 172S9803N225RSMeridian Aircraft LLC · Wilmington, DEBuilt 2022 · S/N 2881543N225SFAb Prop Plane I LLC · Metairie, LABuilt 2025 · S/N 172S13441N225SGWilliams Stephen W · Granbury, TXBuilt 2006 · S/N 1018-2006N225SPGross Flying Service Inc · Larned, KSBuilt 1964 · S/N D-7488N225TCameron Mark · Big Arm, MTBuilt 1969 · S/N 18259960N225TAN225ta LLC · Loganville, GABuilt 1970 · S/N TH-64N225TBHot Wings Aviation LLC · Indianapolis, INBuilt 2023 · S/N 28020127N225TFTop Flight Aviation Inc · Corona, CABuilt 2004 · S/N 172S9755N225THMariner John M · Houston, TXBuilt 2010 · S/N 535-2010N225TMSouth Of Snow Adventures LLC · Hartwell, GAS/N 318152165N225TVBuell Travis · Harper, TXS/N 0253N225TXCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1979 · S/N 18266946N225VBas Part Sales LLC · Greeley, COBuilt 1966 · S/N TE-123N225WCBozeman Skyhawk LLC · Bozeman, MTBuilt 2006 · S/N 172S10272N225WDSvajda David J · Olathe, KSBuilt 2012 · S/N 22209N225WHRobinson Helicopter Co · Torrance, CABuilt 2026 · S/N 15012N225WM225wm Aircraft Leasing LLC · Spanish Fork, UTBuilt 2007 · S/N 4109N225WSSpartan Education LLC · Tulsa, OKBuilt 2005 · S/N 172S9800N225XGomez Miguel W · Livermore, CABuilt 1957 · S/N D-5032N225YWhite Wings LLC · Anchorage, AKBuilt 1990 · S/N 1133N22604Tarten Air Inc · Smiths Creek, MIBuilt 1978 · S/N E-1287N22607Martin Stephen T · Green Cove Springs, FLBuilt 1995 · S/N 001N2260EJm-Bac Holdings LLC · Arcadia, OKBuilt 2007 · S/N 18281939N2260GJump Tn LLC · Greeneville, TNBuilt 1958 · S/N 51560N2260MBomar Robert B · Bedford, TXBuilt 1977 · S/N 28-7816264N2260PToliver David R · Overland Park, KSBuilt 1957 · S/N 23-870N2260SWheeler Eugene N · Livermore, CABuilt 1976 · S/N 21061204N2260TOrtner Airport LLC · Wakeman, OHBuilt 1977 · S/N R18200012N2260YReich Bruce D · Red Oak, IABuilt 1967 · S/N 17700060N2261AFlying Start LLC · Wilmington, DEBuilt 1952 · S/N 18-1887N2261CGandy John W III · Mt Vernon, TXBuilt 1953 · S/N 30561
Back to AD 2007-04-19 R1