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.

N265HPN265hp LLC · Parachute, COBuilt 1985 · S/N 18268519N265JPN265jp LLC · Mill Valley, CABuilt 2004 · S/N 0888N265KBCedaron Medical Inc · Davis, CABuilt 2019 · S/N TH-2523N265MATrevathan Max Tyler · Braggadocio, MOBuilt 2003 · S/N 937-2003N265MESunset Leasing Inc · Sarasota, FLBuilt 2000 · S/N 18280771N265MGGeorgia Aviation Authority · Eastman, GABuilt 2020 · S/N 2881363N265MHHarrington Michael · Twin Falls, IDBuilt 2023 · S/N JA2102153N265NDAri Ben Aviator Inc · Fort Pierce, FLS/N 2842065N265PCSilver Eagle II LLC · Carson City, NVBuilt 1980 · S/N 340A-0996N265PLAdams Aviation Services Inc Trustee · Wilmington, DEBuilt 2025 · S/N 42759N265SFAb Prop Plane I LLC · Metairie, LABuilt 2025 · S/N 172S13409N265TWYale Companies LLC DBA · Indianapolis, INBuilt 2023 · S/N 28020132N265WGelinas Peter L · Burien, WABuilt 1998 · S/N 025N265WYGemini Aviation LLC · Holmdel, NJBuilt 2016 · S/N 3265N2660Applegate Land Holdings LLC · Jacksonville, ORBuilt 1981 · S/N 18268100N26601Trowbridge Rodney L · Haysville, KSBuilt 1968 · S/N 18259083N26602Eastern New Mexico University - Roswell · Roswell, NMBuilt 1988 · S/N 0858N2660AN62689 Inc · Texarkana, TXBuilt 1952 · S/N 18-2184N2660FWheels Up Aviation Inc · Lewes, DES/N 18256760N2660GFruge Cory · Egan, LABuilt 1959 · S/N 51960N2660PAnderson William B · Rogers, ARBuilt 1955 · S/N 22-3000N2660QSummit Aviation LLC · Spokane, WABuilt 1977 · S/N 28-7790413N2660RPa Bo Ma Inc · Alexandria, LABuilt 1967 · S/N 18258360N2660WDeptula John R · Pinehurst, NCBuilt 1966 · S/N 989N2660YRam Aviation LLC · Palmer, AKBuilt 1962 · S/N 18051160N26613Coomes Thomas R · Hollis, OKBuilt 1998 · S/N 18280326N26616Sea Wing LLC · Camarillo, CABuilt 1998 · S/N 18280329N26619Sides Michael E · Bartley, NEBuilt 1988 · S/N 0876N2661ABerry Scott F · Destin, FLBuilt 1968 · S/N 18259102N2661QAlred Robert I · Barrow, AKBuilt 1966 · S/N 18257861N2661TSix One Tango LLC · Pismo Beach, CABuilt 1971 · S/N 28-7205069N2661YAlaska Outdoor Consultants LLC · King Salmon, AKBuilt 1962 · S/N 18051161N2662ARogers Construction Services Inc · Boca Raton, FLBuilt 1998 · S/N 18280331N2662BGjl Aviation LLC · Fort Worth, TXBuilt 1998 · S/N 18280332N2662FGarmin International Inc · Olathe, KSBuilt 1998 · S/N 18280337N2662GWhitman Monty · Pagosa Springs, COBuilt 1959 · S/N 51962N2662TPlane Aviation LLC · Camarillo, CABuilt 1971 · S/N 28-7205070N2662WEaton Mark E · Houston, TXBuilt 1966 · S/N 3312N2662XTail Aero Corp · Wilmington, DEBuilt 1965 · S/N P206-0162N2662ZBidcal Inc · Chico, CABuilt 1998 · S/N 18280338N26630Iasco Flight Training Inc · Redding, CABuilt 1998 · S/N 17280565N2663JN2663j LLC · Rehoboth Beach, DEBuilt 1988 · S/N 0877N2663PHoffrage Michael B · Fresno, CAS/N 22-3003N2663QBerg Weston L · Stanton, NDBuilt 1966 · S/N 18257863N2663XAvolant Aviation LLC · Mooresville, NCBuilt 1999 · S/N 17280643N2663ZVaccaro Glen J · Trinidad, COBuilt 1977 · S/N 362-78N2664Lcj Holdings LLC · Youngsville, LAS/N 310R0195N2664AZmuda Bruce V · Eagle River, AKBuilt 1952 · S/N 18-2179N2664FWisconsin Aviation Inc · Watertown, WIBuilt 1980 · S/N 414A0534N2664KPeters Jeremy D · Nampa, IDBuilt 1947 · S/N 5391
Back to AD 2007-04-19 R1