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.

N3380RHunter Robert R · Springville, PABuilt 1967 · S/N 18258680N3380XGretencord Howard F Trustee · Kansas City, MOBuilt 1966 · S/N 3381N3380YLaramie Flying Club Inc · Laramie, WYBuilt 1962 · S/N 18254380N3380ZSchwend Brian · Forsyth, MTBuilt 1960 · S/N 18-7261N33815Hyde Leasing LLC · Water Valley, MSBuilt 1975 · S/N 28R-7535199N33816Hettinger John E · Sterling, COBuilt 1975 · S/N 28R-7535200N3381FAttema Symon Nmi · Norco, CABuilt 1966 · S/N 18257381N3381UCenter Of Excellence Corp · Cheyenne, WYBuilt 1963 · S/N 18254781N3381XBagwell Trevor T · Valencia, CABuilt 1966 · S/N 3382N3382DBond Jeffrey A · Las Cruces, NMBuilt 1955 · S/N 32180N3382RWatch Out LLC · Scottsdale, AZBuilt 1967 · S/N 18258682N3382SNorthern Sonic Alaska Inc · Fairbanks, AKBuilt 1973 · S/N 18502288N3382WMoffatt Jeffrey Charles · Morgan Hill, CABuilt 1965 · S/N 32-237N3382YJenkinson John III · Lakin, KSBuilt 1962 · S/N 18254382N33831D&K Sales Inc · Canton, GABuilt 1975 · S/N 32-7500032N33836Patton Daniel E · Thornton, PABuilt 1975 · S/N 28-7505186N3383DStyer Michael J · Amarillo, TXBuilt 1955 · S/N 32181N3383RDeatley Derek · Mohave Valley, AZBuilt 1967 · S/N 18258683N3383SStewart Bryan · Carson City, NVBuilt 1969 · S/N 21059183N3383TBerkstresser John A · Ellijay, GABuilt 1967 · S/N 17700683N3383WFour Dudes Flying LLC · Cabot, ARBuilt 1965 · S/N 32-239N3383XHiger Matthew Ward · Las Vegas, NVBuilt 1966 · S/N 1096N3383YJohnson Brian B · Monroe, LABuilt 1962 · S/N 18254383N3383ZMcghee Johnny A · Louisburg, NCBuilt 1960 · S/N 18-7267N33847Registered aircraftBuilt 1975 · S/N 28-7525249N33848Crymes Robert S · Woodbridge, VABuilt 1975 · S/N 28-7505187N33849Sanzaro Aero LLC · Bunnell, FLBuilt 1975 · S/N 28R-7535206N3384R3384 Romeo LLC · Jackson, MOBuilt 1967 · S/N 18258684N3384XWendt Wesley A · Leavenworth, KSBuilt 1966 · S/N 1097N3384YOliveira John S · Plant City, FLBuilt 1962 · S/N 18254384N3384ZJones Robert D Jr · Chugiak, AKBuilt 1960 · S/N 18-7268N33850Jbm Ventures Inc · Apollo Beach, FLBuilt 1975 · S/N 28-7510068N3385LTonka Seaplanes LLC · Minnetonka, MNS/N 185-1337N3385RHill David A Jr · Needham, MABuilt 1967 · S/N 18258685N3385XKelly Paul M · Granite Bay, CABuilt 1966 · S/N 3383N3385YNoah Aviation LLC · Ellabelle, GABuilt 1962 · S/N 18254385N33863N318bm LLC · Monroe, LABuilt 1975 · S/N 28R-7535208N33864Hirsch Bernard David · Carmel, INS/N 32-7500033N338672 F LLC · Valentine, NEBuilt 1975 · S/N 28R-7535209N3386ED Gordon Aviation Inc · La Jolla, CABuilt 1978 · S/N 17271526N3386FN3386f Flying Club Inc · Pickerington, OHBuilt 1966 · S/N 18257386N3386WTranswestern Air Service Inc · Golden, COBuilt 1965 · S/N 32-244N3387FChristensen Robert F · Gillette, WYBuilt 1966 · S/N 18257387N3387RSkypartners LLC · Buhler, KSBuilt 1967 · S/N 18258687N3387TWarner Stephen DBA · Pleasantville, PABuilt 1967 · S/N 17700687N3387USkynick Enterprises Inc · Tarzana, CAS/N 18254787N3387YBhogal Balvinder S · Biloxi, MSBuilt 1962 · S/N 18254387N3387ZBlake Clark D · Belle Fourche, SDBuilt 1960 · S/N 18-7271N3388PMorrison Maria · Port Townsend, WABuilt 1958 · S/N 23-1351N3388RFamily Air Fares LLC · Wilmington, DEBuilt 1967 · S/N 18258688
Back to AD 2007-04-19 R1