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.

N2043SAppel Daniel E · Redfield, SDBuilt 1975 · S/N 21061010N2043XWright Air Service Inc · Fairbanks, AKBuilt 1978 · S/N E-1387N20443Walker Martha D · Auburndale, FLBuilt 1972 · S/N 17261291N20444Cesafsky Allen A · Bend, ORBuilt 1978 · S/N CE-824N20445Norman Chuck DBA · Zanesville, OHBuilt 1972 · S/N 17261293N20448Delta Echo Whiskey LLC · Apopka, FLBuilt 1982 · S/N R18201923N20449J2 Aero LLC · Ringgold, GABuilt 2008 · S/N 0330N2044DMyalik Gennady K · Campobello, SCS/N 0116N2044GSpear Michael J · Sandpoint, IDBuilt 1958 · S/N 51344N2044KSchutze Curt · Knoxville, TNBuilt 1978 · S/N E-1389N2044LLeitner Jay T · Hurst, TXBuilt 1976 · S/N MC-440N2044MDowling Michael L · Adrian, MIBuilt 1977 · S/N 28-7816242N2044PSnoe Gary A · Somerville, TXS/N TC-2178N2044RMiller Steven Chris · Royse City, TXBuilt 1964 · S/N 18255244N2044VPerformance Construction LLC · Paris, TXBuilt 1978 · S/N E-1390N2044WMccraw Richard L Trustee · Hinesburg, VTBuilt 1978 · S/N E-1391N2044XNc Flyers LLC · Raleigh, NCBuilt 1965 · S/N 18256144N2044YPsalm 19:1 Aviation LLC · Annapolis, MDBuilt 2005 · S/N 18281643N20451Registration Pending · Swainsboro, GARegistration pendingBuilt 1972 · S/N 17261297N20452Bay Flying Services LLC · Pinconning, MIBuilt 1972 · S/N 17261298N20454Rl Aviation LLC · Miami, FLBuilt 1972 · S/N 17261300N20455Kachemak Bay Flying Service Inc · Temple, TXBuilt 1972 · S/N 17261301N20457Gulf Atlantic Airways Inc · Gainesville, FLBuilt 1972 · S/N 17261303N2045CBarreto Antonio Trustee · Norco, CABuilt 1978 · S/N E-1392N2045EDouble P Investments LLC · Kerrville, TXBuilt 1978 · S/N E-1393N2045NChristensen Tyler R · Red Bluff, CABuilt 1958 · S/N 186771N2045XOsborne David A · Helotes, TXS/N 18256145N20463Merritt Daniel D · Graham, WABuilt 1981 · S/N 18053187N204648231 Tango Enterprises LLC · Guthrie, OKBuilt 1972 · S/N 17261308N20465C Flyers Inc · Dyersville, IABuilt 1972 · S/N 17261309N2046KChristiansen Aviation LLC · Wilmington, DEBuilt 2017 · S/N 172S12092N2046LRegistration Pending · Bonham, TXRegistration pendingBuilt 1976 · S/N MC-433N2046RBiser Group LLC · Huntington, WVBuilt 1969 · S/N 28-5443N2046SYankee Clipper LLC · Dayton, OHFirst renewal noticeS/N 21061013N2046WKj Cessna LLC · Waxahachie, TXBuilt 1978 · S/N CE-825N2046YBrainerd William F III · Sapello, NMBuilt 1978 · S/N E-1395N2046ZFreedom Flying Club LLC · Fort Collins, COBuilt 1978 · S/N E-1396N20470Dameron Cleveland Forrester · Wicomico Church, VABuilt 1972 · S/N 17261313N20471Cp Aircraft Leasing LLC · Danville, CABuilt 1972 · S/N 17261314N20472N20472 LLC · Opa Locka, FLBuilt 1972 · S/N 17261315N20474Voinovich John · Ogden, UTBuilt 1972 · S/N 17261317N20478V35b Bonanza LLC · Temecula, CAS/N D-10194N2047ABig Bend Community College · Moses Lake, WABuilt 1978 · S/N MB-899N2047BField Inspection LLC · Brawley, CABuilt 1978 · S/N E-1394N2047ESeaside Cycles Inc · Johns Island, SCBuilt 1978 · S/N 17271131N2047GSatina David J · Norton, OHBuilt 1958 · S/N 51347N2047NAwa Aviation LLC · Sacramento, CABuilt 1978 · S/N E-1400N2047PFromknecht Robert L · Quakertown, PABuilt 1978 · S/N E-1401N2047WKapusta Marian · Clearwater, FLBuilt 1965 · S/N D-7986N20481Lesage Robert E · Puyallup, WABuilt 1973 · S/N 17261324
Back to AD 2007-04-19 R1