OpenAirDocs.org
AD 2007-04-19 R1

Registered aircraft · 108,428

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.

N1289UKavak Air Inc · Middletown, DEBuilt 1982 · S/N 21064682N1289XConner James B · Mishawaka, INBuilt 1963 · S/N 162N1289YBravo Leasing LLC · Daytona Beach, FLBuilt 2005 · S/N 172S9851N128ACCga Holdings LLC · Kalispell, MTBuilt 1974 · S/N 61-0170-084N128AEChiave Solutions LLC · Orlando, FLBuilt 1981 · S/N E-1830N128AFSummerskyz Inc · Saint Joseph, ILBuilt 2006 · S/N 11475N128AKMcgill Alvin R · Joliet, MTS/N 133N128ALWilson Timothy S · Newbury Park, CABuilt 2004 · S/N 25006N128ARGeorge'S Aviation Services Inc · Honolulu, HIBuilt 2005 · S/N 4496218N128AVMacair Aviation LLC · Xenia, OHBuilt 1984 · S/N 28-8516007N128BRNautilus Aviation LLC · Yadkinville, NCBuilt 1979 · S/N 414A0231N128BWRodriquez Roy L DBA · Martin, TNBuilt 1969 · S/N 18260080N128CEEarly Roy W · Beaver, PABuilt 2006 · S/N 90989N128CGMontaez Torrez Raul · Guaynabo, PRBuilt 1968 · S/N 17256621N128CPMaule Flight Inc · Moultrie, GAS/N 18066CN128DHMorris Thomas E · Orlando, FLBuilt 1998 · S/N 18040CN128DPGherebi Belaid A · San Diego, CAS/N 28-7125293N128DVAerial Sign North · Lakewood, NJBuilt 1955 · S/N 18-4366N128ESturges John A · Hayden, IDBuilt 1966 · S/N 1190N128EHJen Air LLC · Greenwood, MSBuilt 2003 · S/N 1305N128EPPalicki Anthony J · Huntsville, ALBuilt 1985 · S/N 172-76482N128GRJaques Stanley S · Cassville, MOBuilt 1968 · S/N 28R-30806N128HRDerenick Aviation LLC · Aguadilla, PRS/N 17262679N128JDHopwood Roy Neal · Rio Rancho, NMBuilt 1999 · S/N 24632N128JRMorris Dylan L · Garden Plain, KSBuilt 1976 · S/N 18264785N128KMScott Mark A · Newman Lake, WABuilt 2002 · S/N SWINKELS 801N128KRRogue Texan Outfitters LLC · Skidmore, TXBuilt 1994 · S/N 0047N128KTClaus Logan D · Chitna, AKBuilt 1975 · S/N 18-7509089N128LBWareham Andrew John · Wasilla, AKBuilt 1966 · S/N 30-1132N128LFLewis Michael D · Jenks, OKBuilt 2004 · S/N 81507N128MAFca Flight Center Inc · Fitchburg, MABuilt 1975 · S/N 17263941N128MBParker Rodger D · Sedona, AZBuilt 1981 · S/N 62P08768165013N128MCDawson Aircraft Inc · Clinton, ARBuilt 1984 · S/N 340A1808N128MMBird Cory R · Tehachapi, CAS/N 477RN128MTMiddle Tennessee State University · Murfreesboro, TNBuilt 2003 · S/N 4496171N128PTaddeo Brent J · Cumming, GABuilt 1979 · S/N M-2220N128PBHayes Thomas G · Kerrville, TXBuilt 1966 · S/N 1283N128PFSky West Aviation Inc Trustee · Albuquerque, NMBuilt 2002 · S/N 0218N128PHWayne Terry · Belews Creek, NCBuilt 2023 · S/N 1218N128PSShoen Paul F · Gardnerville, NVBuilt 1964 · S/N 3066N128RVande Hei Joshua G · Kaukauna, WIBuilt 1968 · S/N 17256984N128RSGwizair LLC · Lewes, DEBuilt 1999 · S/N 22078N128SAFly-Right Aviation LLC · Anderson, SCS/N 355N128SCIasco Flight Training Inc · Redding, CABuilt 1999 · S/N 172S8250N128SHCalifornia In Nice Inc DBA · San Jose, CABuilt 2020 · S/N 172S12457N128SMHafford Jay T · Stevenson, WAS/N 1162-79N128SWRegistered aircraftBuilt 1966 · S/N 18051699N128TBlakesmith Don G · London Mills, ILBuilt 1990 · S/N 770N128TTWarner Wings LLC · Yakima, WABuilt 1979 · S/N U20604991N128VMThomas Lucas G · Beebe, ARBuilt 2017 · S/N 585-2017
Back to AD 2007-04-19 R1