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.

N3363YCamlik Air LLC · Wausau, WIBuilt 1978 · S/N 21063145N33640Red Rooster Rentals LLC · Alto, GABuilt 1975 · S/N 28-7515349N33641Sutton Aircraft Salvage LLC · Palmer, AKS/N 28-7505161N33642Smith Gary E · Des Moines, IABuilt 1975 · S/N 28R-7535166N33648Sadiq Ahmed · Ontario, CABuilt 1975 · S/N 28-7525219N3364AVan Heel Tyler R · Newberg, ORBuilt 1969 · S/N CE-287N3364BDilley Darrel L · La Salle, COBuilt 1977 · S/N CE-734N3364DKtr Aviation LLC · Evans, COS/N 32162N3364EPlsr LLC · Denton, TXBuilt 1978 · S/N 17271519N3364FCrouch Jeffrey Lane Jr · Grimesland, NCBuilt 1966 · S/N 18257364N3364SAir Deeken Ltd · Doylestown, OHBuilt 1969 · S/N 21059164N3364THigh Mesa Aviation LLC · Naturita, COBuilt 1967 · S/N 17700664N3364UPalladino Frank · Castleton, NYBuilt 1963 · S/N 18254764N3364WOconnell Killian R · Amherst, MABuilt 1965 · S/N 32-210N3364XDel Bene Dean A Trustee · Monee, ILBuilt 1966 · S/N 1085N3364YSpeth Peter P · Peru, INBuilt 1962 · S/N 18254364N33655Gordon William S III · Aurora, COBuilt 1975 · S/N 28-7525220N33659North Central Flight Center LLC · Warwick, RIBuilt 1975 · S/N 28-7515351N3365BSmith James A · Lyle, WABuilt 1954 · S/N 22-2170N3365FTimlor Inc · Warrenton, ORBuilt 1966 · S/N 18257365N3365SWinger Cattle Co Inc · Johnson, KSBuilt 1969 · S/N 21059165N3366Sutton Aircraft Salvage LLC · Palmer, AKS/N 23-1919N33661Baker Justin Robert · Red Oak, TXBuilt 1975 · S/N 28-7505163N33663Brown Tony Mac II · Bowling Green, KYBuilt 1975 · S/N 28R-7535171N33666Hancock Carl M · Glendale, AZBuilt 1975 · S/N 28-7505165N33667Aptum Aviation Inc · Hicksville, NYBuilt 1975 · S/N 28-7505166N33668Northeast Cubs LLC · Wilmington, DEBuilt 1975 · S/N 28R-7535172N3366PLccc Enterprises Inc · Jupiter, FLBuilt 1966 · S/N 18257084N3366ST R Webster And Son Inc · Rexburg, IDBuilt 1969 · S/N 21059166N3366UAbraham Alan · Pilot Point, TXS/N 18254766N3366YCrawford Stephen E · Corinth, TXS/N 18254366N3367Klaasmeyer Construction Co · Conway, ARBuilt 1966 · S/N TE-146N33672Nulton Enterprises LLC · Johnstown, PABuilt 1975 · S/N 28-7515298N33673Borregard Robert Stephen · San Jose, CAS/N 28-7515306N33674Beaulieu Marc R · Lewiston, MES/N 28-7525222N33676Bous Harry John · Cayce, SCBuilt 1975 · S/N 28-7525224N33679North Star Aviation Inc · Ulysses, KSFirst renewal noticeBuilt 1975 · S/N 28-7505167N3367PJackson Lee Roy Jr · Needville, TXBuilt 1958 · S/N 23-1324N3367RRegistered aircraftS/N 18502875N3367SSierra Co Llp · Wendell, IDBuilt 1973 · S/N 18502280N3367UKellogg David J · Marshall, MIS/N 18254767N33684Coletti John · Grant Park, ILBuilt 1975 · S/N 28R-7535174N3368FA&W Air LLC · Aiken, SCBuilt 1966 · S/N 18257368N3368RRegistered aircraftAssigned, pending cancellationS/N 18258668N3368SForbes Amanda M · Huachuca City, AZBuilt 1969 · S/N 21059168N3368TTuley Richard L · Marietta, GARegistration revokedBuilt 1967 · S/N 17700668N3368UZeigler Ryan C · The Dalles, ORBuilt 1963 · S/N 18254768N3368WRegistration Pending · Bulverde, TXRegistration pendingBuilt 1965 · S/N 32-214N3368XI Have A Plane LLC · Lake Oswego, ORS/N 1087N3368ZWatts Paul D · Weatherford, TXBuilt 1960 · S/N 22-7283
Back to AD 2007-04-19 R1