OpenAirDocs.org
AD 2017-01-07

Registered aircraft · 140

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:2017-01-07')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2017-01-07')
  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.

N37WXCsc Delaware Trust Co Trustee · Wilmington, DEBuilt 2000 · S/N 309N380CJSkyview LLC · Wilmington, DES/N 380N383MCTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2002 · S/N 322N388BBPw Transport LLC · Lafayette, LABuilt 1999 · S/N 281N395HEBillron LLC · Houston, TXBuilt 1992 · S/N 228N396JR396jr LLC · Macon, GABuilt 2005 · S/N 341N404DHDodson International Parts Inc · Rantoul, KSBuilt 1977 · S/N 366N404HRBudget Jet LLC · Delray Beach, FLBuilt 1985 · S/N 455N408CJDt Management Group LLC · Phoenix, AZBuilt 2000 · S/N 293N413VLFalcon Vl LLC · Wilmington, DEBuilt 2006 · S/N 345N438SJKalitta Charters LLC · Ypsilanti, MIBuilt 1981 · S/N 438N481FLIfl Group Inc · Waterford, MIBuilt 1966 · S/N 27N500CFPool Plane LLC · Seattle, WABuilt 2000 · S/N 303N500LY1380 Jets LLC · Pittsfield, MABuilt 2002 · S/N 323N502SVCryptologistics Of America Inc · Southwest Ranches, FLBuilt 1985 · S/N 502N50BLBnb LLC · Wilmington, DES/N 2N50FGRegenerative Sports Tissue Bank Inc · Lawrenceville, GABuilt 1988 · S/N 187N50MWWj Of Delaware Inc · Fort Lauderdale, FLS/N 503N50PCSpritle LLC · Chicago, ILBuilt 2000 · S/N 308N50SNFirst Quality Falcon LLC · Great Neck, NYBuilt 2000 · S/N 310N50YPVillages Equipment Co · Leesburg, FLBuilt 2005 · S/N 344N50YTInternational Aviation Technical Services Inc · Torrance, CABuilt 1996 · S/N 269N510MPPark Avenue Aircraft Trust LLC Trustee · Dover, DEBuilt 1984 · S/N 140N511FLIfl Group Inc · Waterford, MIBuilt 1967 · S/N 122N5123Tpi Aircraft Interiors LLC · New Bern, NCBuilt 1984 · S/N 123N513SKHappy Skies LLC · Dover, DEBuilt 2004 · S/N 338N516CJTotal Aviation Corp · Garden City, NYBuilt 1980 · S/N 016N520AWGg Flight LLC · Findlay, OHBuilt 1981 · S/N 453N520TCDodson International Parts Inc · Rantoul, KSS/N 319N521FLIfl Group Inc · Waterford, MIBuilt 1967 · S/N 68N522EECenergistic LLC · Dallas, TXBuilt 1999 · S/N 282N531FLIfl Group Inc · Waterford, MIBuilt 1967 · S/N 113N54YPPhifer Inc · Tuscaloosa, ALBuilt 2003 · S/N 333N550WMWno Trust Services LLC Trustee · Wilmington, DEBuilt 1992 · S/N 229N556HDN50hd LLC · Salt Lake City, UTBuilt 2002 · S/N 321N55HSRapid Leasing Inc · Cedar Rapids, IABuilt 1998 · S/N 276N58HLGreen Button Holdings LLC · Overland Park, KSBuilt 1999 · S/N 279N59YPNextgen Flying LLC · The Villages, FLBuilt 1998 · S/N 275N600CDKalitta Charters LLC · Ypsilanti, MIBuilt 1978 · S/N 377N600JBOgden Aviation LLC · Hinsdale, ILBuilt 1998 · S/N 272N600LYMajjec Jhett LLC · Springfield, MABuilt 2004 · S/N 337N600RARoyal Air Freight Inc · Waterford, MIBuilt 1984 · S/N 296N604PTR3hd Air LLC · Marietta, GABuilt 1969 · S/N 202N618GHDodson International Parts Inc · Rantoul, KSBuilt 1987 · S/N 513N649TTTownes Aircraft Sales LLC · Paris, TXBuilt 2005 · S/N 342N66EWTechnical Support Services Inc · Toledo, OHS/N 492N67MTWindway Capital Corp · Sheboygan Falls, WIBuilt 1996 · S/N 254N680JSBank Of Utah Trustee · Salt Lake City, UTBuilt 2006 · S/N 349N68UPRoyal Air Freight Inc · Waterford, MIBuilt 1971 · S/N 258N68YBCzzc Aviation LLC · Tucson, AZBuilt 1999 · S/N 290
Back to AD 2017-01-07