OpenAirDocs.org
AD 2007-03-17 R1

Registered aircraft · 999

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-03-17-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-03-17-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.

N881ATColbalt Elemental LLC · Seattle, WABuilt 2009 · S/N 515N883CRHoffman Travis K · Maroa, ILS/N 83N885CAGrand Air LLC · Twin Falls, IDS/N 363N888PAEquestrian Connect LLC · Woodside, CABuilt 2022 · S/N 1431N889PCorvus Air LLC · Centennial, WYBuilt 2013 · S/N 669N88CDBlue Sky Travel LLC · Houston, TXBuilt 2014 · S/N 1027N88HALucky Five LLC · Charleston, MOBuilt 2017 · S/N 1163N8904M659b Flight LLC · Mason, MIBuilt 2008 · S/N 493N8912TRaw Dog Air LLC · Los Altos, CABuilt 2017 · S/N 1166N893MAAir Woody LLC · Missoula, MTBuilt 2015 · S/N 1065N894EAMeridian Aviation LLC · Boston, MABuilt 2007 · S/N 416N897TFSts Inc · Wilmington, DEBuilt 2020 · S/N 1324N8CDIndigo Aviation LLC · Schriever, LABuilt 2008 · S/N 468N8KFRio Brazos Aviation LLC · Waco, TXBuilt 2008 · S/N 466N8KULange Jonathan E · Seattle, WABuilt 2004 · S/N 304N8YWAv Serv LLC · Dover, DEBuilt 1996 · S/N 113N900ARTj Air Holdings Inc Trustee · Wilmington, DEBuilt 1992 · S/N 32N900AYBruce M Feldstein Dds Pc · Beaufort, NCBuilt 2015 · S/N 1081N900AZGwin Jeffrey · Enid, OKBuilt 2014 · S/N 1000N900CNBlue Lake Enterpises LLC · Incline Village, NVBuilt 2014 · S/N 1001N900CUBoerne Flight Options LLC · Wilmington, DEBuilt 2015 · S/N 1090N900CXJd Haaland Construction Inc · Palo Alto, CABuilt 2015 · S/N 1075N900CYUnverferth Manufacturing Co · Kalida, OHBuilt 2015 · S/N 1068N900DGCaterers Leasing Inc · Downey, CABuilt 2002 · S/N 225N900EHTj Air Holdings Inc Trustee · Wilmington, DEBuilt 2015 · S/N 1082N900EPPc Express Inc · Austin, TXBuilt 2015 · S/N 1087N900EWUhv Sputtering Inc · Morgan Hill, CABuilt 2015 · S/N 1096N900EYRiver Rock Aviation LLC · Kingman, AZBuilt 2015 · S/N 1101N900FAGkw Elite LLC · Wilmington, DEBuilt 2015 · S/N 1073N900FKDodson International Parts Inc · Rantoul, KSS/N 1097N900FZSkyrider Aviation LLC · Wilmington, DEBuilt 2016 · S/N 1108N900GKClaypool James B · Bellevue, WABuilt 2014 · S/N 1029N900GNZelbst John P · Lawton, OKBuilt 2016 · S/N 1109N900JVJebry Leasing LLC · Jenks, OKBuilt 2014 · S/N 1026N900LHLittle Hawk Logistics LLC · North Garden, VABuilt 2015 · S/N 1056N900MELittle Hawk Logistics LLC · North Garden, VABuilt 2014 · S/N 1048N900NPNorthland Airmotive LLC · Waterloo, IABuilt 2014 · S/N 1033N900RJMk Tbm 930 LLC · New York, NYBuilt 2016 · S/N 1113N900TK4tb Av8n LLC · Naples, FLBuilt 2015 · S/N 1069N900TWAlphapop2 LLC · Windham, NYBuilt 2014 · S/N 1006N900TYComstock Crosser & Associates Development Co LLC · Long Beach, CABuilt 2015 · S/N 1084N900TZYankee Aviation LLC · Berwyn, PABuilt 2015 · S/N 1088N900VVWhite Mountain Air LLC · Pinedale, WYBuilt 2014 · S/N 1011N900WFWood Farms Transportation Inc · Birmingham, ALBuilt 2014 · S/N 1004N900ZFTraceyk Aviation LLC · Spring, TXS/N 1104N900ZPTripp Aviation LLC · Burlington, NDBuilt 2015 · S/N 1062N901JFRegistered aircraftBuilt 2015 · S/N 1094N902TMLadera Aircraft LLC · Fullerton, CABuilt 2015 · S/N 1103N903MATrue Story Aviation LLC · Lincoln, NEBuilt 2004 · S/N 308N904EATrophy Trucking Services LLC · Burleson, TXBuilt 2016 · S/N 1118
Back to AD 2007-03-17 R1