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.

N3657NEstes Aviation LLC · Vicksburg, MSBuilt 1967 · S/N 680027N3657QFaith Builders Family Church Inc · Rogers, ARBuilt 1968 · S/N M-1136N3657YSims Daniel G · Martinez, CABuilt 1963 · S/N 21058157N3657ZBagdon Albert B · Elbert, COBuilt 1960 · S/N 22-7554N36583Pray Aviation Inc · Augusta, KSBuilt 1978 · S/N 28-7816647N36588Moseley Richard W · Lakewood Ranch, FLBuilt 1978 · S/N 32R-7885196N3658WFlying 20 Club Inc · Springfield, ILBuilt 1966 · S/N 32-564N3658YJo Co Inc · Knoxville, TNFirst renewal noticeBuilt 1963 · S/N 21058158N36590American Aircraft Sales LLC · Lincolnshire, ILBuilt 1978 · S/N 32R-7885197N36593Kentucky Stick And Rudder Academy LLC · Springfield, KYBuilt 1973 · S/N 112-73N36594Hayward Casey W · Anchorage, AKBuilt 1973 · S/N 578-73N3659CWhite Paul S · Clarksville, TNBuilt 1954 · S/N 31158N3659KDumont Mark · Brush Prairie, WABuilt 1967 · S/N 28-23676N3659MTrent Daniel E · Las Vegas, NVBuilt 1978 · S/N 28-7890320N3659RInternational Air Services Inc Trustee · Carson City, NVBuilt 1970 · S/N 28-5762N3659XAiello Bailey H · Eugene, ORBuilt 1968 · S/N 311N3659YPeterson Laurel R · Hart, MIBuilt 1963 · S/N 21058159N365ACEvalidate LLC · Birmingham, MIBuilt 1988 · S/N EA-479N365BMiles Barrington K · Austin, TXBuilt 1957 · S/N D-4995N365BSHarders Justin M · Cairo, NEBuilt 2024 · S/N 009N365CB.R.S. Leasing Inc · Wilmington, DEBuilt 2001 · S/N 2163N365CACivil Air Patrol · Maxwell Afb, ALBuilt 2008 · S/N 18282117N365CCSki Sawmill Family Resort Inc · Ulysses, PABuilt 2004 · S/N 9963CCN365DAJeffries Ian Mcgoff Douglas · Clover, SCBuilt 2013 · S/N 82704N365DBRutan Aircraft Flying Museum · Waller, TXBuilt 2012 · S/N 1697N365DLSoehner Harold D · Winslow, AZBuilt 2009 · S/N DAL001N365DRPace Ryan · Morgan, UTBuilt 2023 · S/N 002N365FCRegistration Pending · Kalispell, MTRegistration pendingBuilt 1973 · S/N 18502233N365HStavair LLC · Gulf Breeze, FLBuilt 1965 · S/N TC-843N365MADip Aviation LLC · Fort Lauderdale, FLBuilt 1999 · S/N 18280582N365MEEhnisz Craig T · Monterey, CABuilt 2000 · S/N 18280855N365MKNorth Star Aviation Inc · Mankato, MNBuilt 2023 · S/N 2881688N365MSMaloney Leasing LLC · Tupelo, MSBuilt 2024 · S/N 14746N365NGReid Michael V · Sulphur Springs, TXBuilt 1968 · S/N 28-11124N365PARotor Leasing LLC · Indianapolis, INBuilt 2017 · S/N 1183N365PCWings Over Texas Holdings LLC · Denton, TXBuilt 1978 · S/N 17271033N365PSFainer Jeffrey M · San Diego, CABuilt 1978 · S/N AA5A0552N365RVTwin Oaks Aviation Inc · Pipersville, PAS/N E-1840N365RWWalter Aviation · Perry, IABuilt 1990 · S/N 903N365SBClear Skys LLC · O Fallon, ILBuilt 2013 · S/N E-4010N365SPClow International Airport LLC · Bolingbrook, ILBuilt 2001 · S/N 172S8783N365TGengarelly Robert M · Benson, AZBuilt 2011 · S/N 72419N365USTecnam US Inc · Sebring, FLBuilt 2021 · S/N 165/USN365WCCrane Douglas F · Ukiah, CABuilt 2002 · S/N 18281170N36601Frett Dennis R · Windsor, MOBuilt 1978 · S/N 28-7816671N36602B2 W Corporation · Winona, MNBuilt 1978 · S/N 28-7816672N36603J&J Holdings Of Pella LLC · Pella, IABuilt 1978 · S/N 28-7816673N3660RBackcountry Wings LLC · Gig Harbor, WABuilt 1970 · S/N 28-5764N3661Mckenna Kent T · Torrance, CAFirst renewal noticeBuilt 1969 · S/N 070N36615Booth Warren Russell · Doylestown, PABuilt 1978 · S/N 32-7840166
Back to AD 2007-04-19 R1