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.

N262ALDale County Sheriffs Office · Ozark, ALBuilt 1981 · S/N R18201836N262AMChapman Kevin Joseph · Williston, NDBuilt 2004 · S/N 2262N262APKirk Donald D · Fairbanks, AKBuilt 1975 · S/N 18502645N262BGLarmore James N · Tucson, AZBuilt 2001 · S/N 0061N262CACompass Aviation Inc · Shelby, NCBuilt 1981 · S/N U20606094N262CBCalifornia Baptist University · Riverside, CABuilt 2018 · S/N 2881005N262CCHorton Charles M · Buckley, WABuilt 1962 · S/N NAV-4-2462N262CLGiga Energy Inc · Buna, TXBuilt 2004 · S/N 18281497N262CPCivil Air Patrol · Maxwell Afb, ALBuilt 2017 · S/N 18283017N262DQIschi Phillip · Soldotna, AKBuilt 1978 · S/N U20604479N262E349 Ez LLC · Yakima, WABuilt 1984 · S/N 262N262EAJeaps Aviation LLC · Edgewater, FLBuilt 2001 · S/N E-3417N262EEHorizon Flights Corp · Henderson, NVBuilt 1973 · S/N 17261621N262ERRoseville Aviation LLC · Roxboro, NCBuilt 1975 · S/N 17263854N262ESBreshears Michael · San Antonio, TXBuilt 1986 · S/N 425N262GCSlepica Michael · Oregon, WIS/N 32R-7985030N262GGN262ggllc LLC · Reno, NVBuilt 1967 · S/N 28-10934N262GRDr I T Help LLC · Cheyenne, WYBuilt 1996 · S/N 21387N262GSMinor Michael D · Grove City, PAS/N 18265183N262MGordon Bruce · Marstons Mills, MABuilt 1976 · S/N 17268356N262MJGillian Michael J · Batavia, ILBuilt 2001 · S/N 29N262MTBurns Mark R · Streetsboro, OHBuilt 2016 · S/N 18282449N262NDMoore Aviation Inc · Beaver Falls, PABuilt 1999 · S/N 2842061N262NJJ2environmental LLC · Del Mar, CABuilt 2012 · S/N 41147N262PDGritter Richard J · Catlett, VABuilt 1991 · S/N 01N262PEPorter Randall L · Athol, IDBuilt 1971 · S/N 492N262PMBig Bend Community College · Moses Lake, WABuilt 1992 · S/N CE-1681N262R262r LLC · Richland, WABuilt 1966 · S/N 28-21931N262RMDisrud Roger G · Olathe, KSBuilt 2002 · S/N 80153N262RNPro Southern Aviation LLC · Franklin, NCBuilt 2001 · S/N 0034N262SASundance Airport LLC · Yukon, OKBuilt 1967 · S/N 28-4047N262WPage Jeffrey Vernon · Washington, PABuilt 1966 · S/N CD-1031N262WYMoore Enterprises Leasing Inc · Indianapolis, INBuilt 2016 · S/N 3262N262XPrice Scott K · Sparks, MDBuilt 1973 · S/N 28R-7335286N26300Boyer Steven L · Wooster, OHBuilt 1977 · S/N AA5A0513N26304Cobra Kai Inc · Wichita Falls, TXBuilt 1977 · S/N AA5A0522N2630GMarvil Sean · El Prado, NMS/N 51930N2630MMock Air LLC · Marion, INBuilt 1979 · S/N 17271166N2630QParrington Robert · Rifle, COS/N 18257830N2630RBurdine Kenneth L · Newland, NCS/N 18258330N2630UShaka Skies LLC · Kihei, HIBuilt 1998 · S/N 17280568N2630XBbjc Adventures LLC · Jackson, WIBuilt 1965 · S/N P206-0130N26314Allen James R · Glasgow, KYBuilt 1978 · S/N AA5A0529N2631CAndrews John M · Titusville, FLBuilt 1978 · S/N R18200183N2631FShepherd Thomas A · Montgomery, NYFirst renewal noticeBuilt 1965 · S/N 18256731N2631GMac Neil David M · Clarkston, WABuilt 1959 · S/N 51931N2631PFriebel Mark A · Shelby, OHBuilt 1955 · S/N 22-2968N2631QManning Brian A · Malvern, IABuilt 1966 · S/N 18257831N2631SAsplundh Eric P · Bryn Athyn, PABuilt 1979 · S/N 310R1620N2631WPlanes & Parts Inc · Weston, FLBuilt 1966 · S/N 3299
Back to AD 2007-04-19 R1