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.

N3355BGar Aviation Inc · Lexington, ORBuilt 1954 · S/N 18-3308N3355EMiddletown Regional Flight Training Institute LLC · Middletown, OHBuilt 1978 · S/N 17271515N3355RSkyhawks Flying Club Inc · Canton, SDBuilt 1967 · S/N 18258655N3355WBland Joseph G · Gainesville, TXBuilt 1965 · S/N 32-198N3355ZSmp Wind River LLC · Thermopolis, WYBuilt 2005 · S/N 22576N33560Sherron Jim Kemp IV · Raleigh, NCS/N 28-7525207N33562Aiken Flyers LLC · Aiken, SCS/N 28-7525208N33563Cape Fear Aviation Services LLC · Fayetteville, NCBuilt 1975 · S/N 28-7515346N33565James Harris · Helotes, TXBuilt 1975 · S/N 28-7505158N33566Roebke Karen L Trustee · Gilbert, AZBuilt 1975 · S/N 28R-7535161N33567R Merritt Investments Inc · Jonesville, MIBuilt 1975 · S/N 28R-7535162N33568Papoi Benjamin F · Phoenix, MDBuilt 1975 · S/N 32-7500025N3356DShapiro David M · Homer, AKBuilt 1994 · S/N 2461N3356FShroyer Scott E · Peyton, COBuilt 1966 · S/N 18257356N3356MH E P Flying Club Corp · Wyoming, MNBuilt 1947 · S/N 12-2184N3356SBbt Inc · Wilmington, DEBuilt 1969 · S/N 21059156N3356TCarlin Joseph A Jr · Rapid City, SDS/N 17700656N3356WFive Six Whiskey LLC · Plainfield, INBuilt 1965 · S/N 32-200N33575Nationwide Aviation LLC · Hudson Oaks, TXS/N 28-7515347N3357DHodel Lawrence E · Hayden, IDBuilt 1955 · S/N 32155N3357KNewman Steve M · Portland, ORS/N 1350N3357LMark II Aviation LLC · Corvallis, MTBuilt 1967 · S/N 185-1309N3357THigh West Aero LLC · Broadus, MTBuilt 1967 · S/N 17700657N3357URunway Ventures LLC · Salida, COBuilt 1963 · S/N 18254757N3357ZHannon Harland N · Big Lake, AKBuilt 1960 · S/N 22-7297N3358AWagner Richard L · Willis, TXBuilt 1969 · S/N D-9062N3358RHaydukovich Steven J · Phoenix, AZBuilt 1967 · S/N 18258658N3358UBratcher Michael · Elizabethtown, KYS/N 18254758N33595N33595 Cherokee LLC · Austin, TXBuilt 1975 · S/N 28-7525211N33599A & Aviation LLC · Pinellas Park, FLBuilt 1975 · S/N 28R-7535165N3359FHughes John · Almira, WABuilt 1966 · S/N 18257359N3359MWarren Wesley L · Coeur D Alene, IDBuilt 1947 · S/N 12-2216N3359TDuquette Robert R · Elfrida, AZS/N 17700659N3359WMcmaster James R II · Bath, PABuilt 1965 · S/N 32-205N3359ZKistler Stephen M Trustee · Monument, KSBuilt 1960 · S/N 22-7299N335ACRegistration Pending · Fort Pierce, FLRegistration pendingBuilt 2006 · S/N 2842274N335APAndy Petree Inc · Denver, NCBuilt 2012 · S/N 13376N335BBVantrease David A · Wills Point, TXBuilt 1983 · S/N 24-1367N335BFSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1966 · S/N 30-1389N335BGBowling Green Flight Center LLC · Bowling Green, OHBuilt 2018 · S/N 2881085N335BWThorp T-18 Ri LLC · Foster, RIFirst renewal noticeBuilt 1995 · S/N 720N335CBAlcala Miguel Arturo Astorga · Gilbert, AZBuilt 1995 · S/N 3290N335CMPura Plastic Surgery LLC · Doral, FLBuilt 1980 · S/N 414A0418N335DDJab Aviation Inc · Wilmington, DEBuilt 1980 · S/N 335-0049N335DPAdvanced Aviation Group LLC · Frederick, MDBuilt 1993 · S/N 2372N335DSWhitaker Martin · Portland, MEBuilt 2008 · S/N 10702008N335FDRoy Martin P · Chehalis, WABuilt 1989 · S/N 335N335HCOtis Stephen H · Mcalester, OKBuilt 2006 · S/N 022N335HPOlympus Leasing LLC · Bremerton, WABuilt 1992 · S/N CE1663N335JAAstrologo Joseph A Jr · Tullahoma, TNBuilt 1964 · S/N D-7576
Back to AD 2007-04-19 R1