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.

N261CCCook Christopher · Columbus, GABuilt 2019 · S/N 82373N261DMOelmann Dennis J · Waverly, IAS/N 379N261DRSafeflite Aviation LLC · Glenwood, IAS/N 31114N261EABrownstone Aviation II LLC · Houston, TXBuilt 2001 · S/N E-3423N261EMJeffrey Brian Cooper · Poway, CAS/N 18260587N261EPEpic Aviation Inc · Denison, TXBuilt 2026 · S/N 172S13501N261EZZokpodo Emmanuel K · Sacramento, CABuilt 1975 · S/N 28R-7635087N261FAStratus Rr LLC · New Castle, DEBuilt 2026 · S/N 28020259N261FCVu Ai · Aiea, HIBuilt 1968 · S/N 28-24697N261GVBohn Jim A · Mead, WAS/N 18253174N261HHoward Clifford E · Auburn, WABuilt 1968 · S/N R.E.C.2N261JBoard Of Trustees Of Southern Illinois University · Murphysboro, ILBuilt 2020 · S/N 172S12575N261KTFrisch Adam · Los Angeles, CAS/N 61P-0437-163N261MGGeorgia Aviation Authority · Eastman, GABuilt 2020 · S/N 2881311N261MMCockroft Scott · Kersey, COBuilt 2000 · S/N 30015CN261REPeterson Randy J · Sonoma, CAS/N 35284N261RMOlandese Donald J · Newalla, OKBuilt 2011 · S/N 91507N261SBird Frank III · Jennings, FLBuilt 1965 · S/N 65-12696N261SCIndia Aviation LLC · Oregon City, ORBuilt 2025 · S/N 172S13439N261SSScopellite Sebastian · Phoenix, AZS/N 18261130N261VFBickley Clarence R · Jefferson, GABuilt 1989 · S/N 576RN261WYFoss Jared K · Greenbush, MNBuilt 2016 · S/N 3261N261XEvans Dennis · Naples, FLBuilt 2000 · S/N 60239N26206Breakey Phillip · Pickerington, OHBuilt 1977 · S/N AA5A0471N2620CWhalen Shenandoah · Amelia, OHBuilt 1987 · S/N 0725N2620FWood Don B · Centerville, UTBuilt 1965 · S/N 18256720N2620GBas Part Sales LLC · Greeley, COS/N 51920N2620MBooth Chance · Wasilla, AKBuilt 1946 · S/N 12-1091N2620QAkroyd Robert F Jr · Raton, NMBuilt 1967 · S/N 18257820N2621FGallaher Boyd H · Prescott, AZBuilt 1965 · S/N 18256721N2621GAdamic David J · Cedar Hills, UTBuilt 1959 · S/N 51921N2621KBasmajian Zachary Robert · Peoria, AZBuilt 1954 · S/N 54-2629N2621MWestern Oklahoma Aviation LLC · Clinton, OKBuilt 1977 · S/N 28-7816297N2621QBrown Russell C · Howey, FLBuilt 1977 · S/N 28-7725202N2621ZWifa (Washington International Flight Academy) LLC · Gaithersburg, MDBuilt 1998 · S/N 17280559N26225Kilday Klayton D DBA · Dexter, ORBuilt 1989 · S/N 1138N2622FFlying Wolves Inc · Arnegard, NDBuilt 1965 · S/N 18256722N2622GKaplan Steven M · North Monmouth, MES/N 51922N2622HBurgess John H · Tower, MNS/N 001N2622MN2622m LLC · Rehoboth Beach, DEBuilt 1982 · S/N 0735MN2622TStenvers Aaron · Valley, NEBuilt 1991 · S/N 1823N2622WMohamed Eman Z · Lubbock, TXBuilt 1966 · S/N 3295N2622YPiatt Matthew D · Wasilla, AKBuilt 1962 · S/N 18051122N26234Compositec Inc · Manitowoc, WIS/N AA5A0458N26236Mcdonnel Jack Edward Jr · Woodsboro, TXBuilt 1977 · S/N AA5A0475N26237Registration Pending · Spokane, WARegistration pendingBuilt 1977 · S/N AA5A0476N26239Rice Grantland S · Boston, MABuilt 1977 · S/N AA5A0477N2623BWalton Indy R · Soldotna, AKS/N 5160N2623CDodson International Parts Inc · Rantoul, KSBuilt 1978 · S/N R18200179N2623GHubbard James D · Jacksonville, TXBuilt 1959 · S/N 51923
Back to AD 2007-04-19 R1