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.

N2966FNansen Peter D · Bellingham, WABuilt 1966 · S/N 18257066N2966KMichels LLC · Wasilla, AKBuilt 1980 · S/N 18053140N2966LCarpenter Robert E · Huntsville, ALBuilt 1967 · S/N 670100N2966RTobin Michael A · Plain City, OHBuilt 1969 · S/N 28R-35351N2966TThomas Paul J · Oakland, MDBuilt 1966 · S/N 339N2966YPiper Holdings LLC · Osage Beach, MOFirst renewal noticeBuilt 1979 · S/N 32R-8013003N2966ZKieffer William · Chillicothe, MOS/N 22-6940N29673Olson Andrew S · Copper Canyon, TXBuilt 1968 · S/N 17701018N29677Anderson Aircraft Inc · Central City, NEBuilt 1979 · S/N 28-7911186N2967DCalifornia In Nice Inc · San Jose, CABuilt 1979 · S/N 44-7995321N2967EBme N2967e LLC · Clearwater, FLBuilt 1978 · S/N 17271391N2967L2967lima LLC · Scott City, MOS/N 670101N2967QPowell Samuel C · Burlington, NCBuilt 1979 · S/N 32-7940243N2967ZChance Carl R · Victoria, TXS/N 22-6941N2968AMcdowell Claude Michael · Anchorage, AKBuilt 1953 · S/N 30168N2968PRankin Kevin · Maryville, MOBuilt 1955 · S/N 22-3242N2968XJansen Edward M · Hummelstown, PABuilt 1967 · S/N 17700368N2968ZKuebler Terry T · Gahanna, OHFirst renewal noticeBuilt 1959 · S/N 22-6943N2969LSeegers Matt J · Westlake Village, CABuilt 1967 · S/N 670328N2969SJorgensen Richard J · Vail, AZBuilt 1979 · S/N 28-8090013N2969TDoskicz Aircraft Specialties Inc · Bally, PABuilt 1966 · S/N 342N296AQMcdonald Gregory W · Newnan, GABuilt 2025 · S/N 74963N296AREnvation LLC · Winter Haven, FLBuilt 1977 · S/N 32-7840063N296BJc Aircraft Leasing LLC · Wasilla, AKBuilt 1964 · S/N TC-600N296BCKrein Christopher L · Bismarck, NDS/N 18-7877N296BJQualitair LLC Trustee · MichelstadtBuilt 1965 · S/N 21058697N296CAAlice Aviation LLC · Atlanta, GAS/N 28-7415494N296CBCalifornia Baptist University · Riverside, CABuilt 2018 · S/N 2881008N296CPCivil Air Patrol · Maxwell Afb, ALBuilt 2007 · S/N 18281995N296DBWopuna Aviation LLC · Vancouver, WABuilt 1999 · S/N 23615N296DJPizzo Duane G · Warren, ORBuilt 1995 · S/N 296N296HLMcclanahan Edward A · Apo, AEBuilt 1980 · S/N M-2275N296HPInnova Air LLC · Encinitas, CABuilt 1996 · S/N 3246059N296JPJpm Flying Service LLC · Marine, ILBuilt 1951 · S/N 181185N296JRRosson Jeffrey K · Melbourne, FLBuilt 2012 · S/N 91599N296LCCox Bradley K · Fairbanks, AKBuilt 2022 · S/N 576EN296MAHot Wings Aviation LLC · Fishers, INBuilt 2026 · S/N 28020266N296MEJwl Aviation LLC · San Carlos, CABuilt 2000 · S/N 172S8554N296NWNorthwestern Michigan College · Traverse City, MIBuilt 2011 · S/N 172S11096N296PEPhoenix East Aviation LLC · Daytona Beach, FLBuilt 2006 · S/N 172S10211N296PLAerospring Leasing LLC · Wasilla, AKBuilt 2025 · S/N 172S13324N296QSteffens Robert S · Peapack, NJBuilt 1975 · S/N 316N296RVRwa Inc · Garden City, KSBuilt 2001 · S/N 60294N296SDHaynie Sidney S · Sedona, AZBuilt 2022 · S/N 74248N296TWN296tw LLC · Murrieta, CABuilt 1992 · S/N 2441N296TXCrowley Michael G · Midland, TXBuilt 2022 · S/N 91438N2970CClegg Bruce R · Brentwood, CABuilt 1954 · S/N 30870N2970ESparrowhawk Aviation · Manvel, TXBuilt 1978 · S/N 17271393N2970NGilcrease Patrick C · Rapid City, SDBuilt 1979 · S/N 28-7911283N2970PWilson Julie · Prineville, ORBuilt 1955 · S/N 22-3244
Back to AD 2007-04-19 R1