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.

N222USTicoair LLC · Wilmington, DEBuilt 1979 · S/N 17273491N222UWFlyin In Style LLC · Greenwood, MSBuilt 1979 · S/N EA-49N222VBGalaxy Aviation LLC · Nantucket, MAS/N 10009N222VCMatlock Gary W · Burleson, TXBuilt 1969 · S/N CE-273N222VSCharlie Rogers Ford Inc · Dayton, TNBuilt 2000 · S/N 29-0222N222VWCool Beans LLC · Newtown, PAS/N 18280085N222WAWiseman Aviation Inc · Flagstaff, AZS/N R18201443N222WFBailey Steve · Chehalis, WABuilt 1963 · S/N 205-0220N222WGWalker Scott Aviation LLC · Woodward, OKBuilt 1978 · S/N M-2092N222WSCenterline Aviation Services LLC · Huntsville, NCS/N TC-1311N222XLFox Jeffery R · Spooner, WIBuilt 1981 · S/N 18504278N222XMSchlasinger Larry DBA · Chetek, WIBuilt 1998 · S/N 18280119N222XPMarshall Greg J · Alexandria, VABuilt 2021 · S/N 102N222YYMerlin Aviation LLC · Fairfield, CTBuilt 2005 · S/N 1458N2230CHendricks Construction LLC · Phoenix, AZS/N 30530N2230DHendricks Construction LLC · Phoenix, AZBuilt 1976 · S/N 18503053N2230TWhite Pelican LLC · Union City, TNBuilt 1971 · S/N 28-7105189N2230XPoff Matthew W · Miramar Beach, FLBuilt 1979 · S/N 28-7990374N2231EState Of Iowa · Des Moines, IABuilt 2007 · S/N 18281924N2231FSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2007 · S/N 18281925N2231GKelly Richard · Ogdensburg, NYS/N 51531N2231JWares Auto Sales Inc · Traverse City, MIBuilt 1978 · S/N 32R-7985053N2231MGreat Lakes Aviation Services Inc · Kimball, MIS/N 32-975N2231THewitt David E · Newcastle, MEBuilt 1968 · S/N 185-1383N2232Reigle Aviation · Palmyra, PABuilt 1971 · S/N 1-GPN2232ASummit Air LLC · Clarks Summit, PABuilt 1976 · S/N 28-7690460N2232BLucky Dog Land Co LLC · Caldwell, IDBuilt 1990 · S/N 512N2232EPink Skies Inc · Willoughby, OHBuilt 1978 · S/N 17271195N2232FPritchard Dale G · St Maries, IDBuilt 1966 · S/N 310L-0032N2232GBigler Mark · Topeka, KSS/N 51532N2232LDodson Jack Yii · Douglasville, GABuilt 1976 · S/N MB-819N2232NKnoll Guenter Wilhelm · Belton, SCBuilt 1979 · S/N 28-7990283N2232QStender Michael L · Davenport, IABuilt 1979 · S/N 28-7911106N2232WJkj Aviation · Wilmington, NCBuilt 1979 · S/N 28-7916334N22334Fredericks Hall Aviation LLC · Mineral, VABuilt 1977 · S/N TE-1111N22336Goldshlager Benjamin · Boca Raton, FLBuilt 1978 · S/N 28-7911004N2233BRollin Virginie C · Mountain House, CABuilt 1978 · S/N 28-7816598N2233CFreeland Robert D · Victor, MTBuilt 1978 · S/N 28-7990147N2233GA F Flyers LLC · American Falls, IDBuilt 1958 · S/N 51533N2233LBecker Leo Henry · Leavenworth, KSBuilt 1979 · S/N 32-7940028N2233MPutnam John P · Weirsdale, FLS/N 18280069N2233PAeroplanes Over Idaho · Caldwell, IDS/N 23-842N2233RDorman William James Trustee · Anchorage, AKBuilt 1975 · S/N 18502859N2233SRichardson Robert O · Spring Grove, ILBuilt 1976 · S/N 21061178N2233TSeward Air Taxi LLC · Seward, AKS/N 185-1386N2233XSpector Arnold · Stamford, CTBuilt 1979 · S/N 28-7990368N2234FMoore Aviation LLC · Cedar Springs, MIBuilt 1978 · S/N 28-7990207N2234GBaldwin Trevor K · Owasso, OKBuilt 1958 · S/N 51534N2234PDanhauer Jeffrey · Owensboro, KYBuilt 1974 · S/N 761-74N2234QJocz Mike · Clifton, VAS/N 30-0052
Back to AD 2007-04-19 R1