Registered aircraft · 2,524

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

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:2014-17-08-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:2014-17-08-R1') ORDER BY n_number

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:2014-17-08-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:2014-17-08-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.

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:2014-17-08-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:2014-17-08-R1')
ORDER BY n_number

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

N511TAAir Med Services LLC · Lafayette, LABuilt 1999 · S/N BB-1660 N5120EC & L Holzwarth Inc · Virden, ILBuilt 1998 · S/N 402B-1052 N5123UR & D Leasing Inc · Lemoore, CABuilt 1997 · S/N 802A-0053 N5127BFarmair LLC · Lagrange, INBuilt 1997 · S/N 502B-0437 N5128NBasin Aviation Inc · Rio Oso, CABuilt 1998 · S/N 402A-1054 N513JMBank Of Utah Trustee · Salt Lake City, UTBuilt 1991 · S/N LJ-1274 N51441Sunset Holdings LLC · Ketchikan, AKBuilt 1960 · S/N 409 N5144DKeo Ag Service Inc · Keo, ARBuilt 1998 · S/N 802A-0062 N5149TFitchs Flying Service LLC · Pearsall, TXBuilt 1998 · S/N 502B-0531 N514RSScherer Robert P Trustee · Aspen, COBuilt 1994 · S/N NC-51 N515CTMalibu LLC · Portland, ORS/N 46-97048 N515PEDog Is My Copilot Inc · Jackson, WYBuilt 2007 · S/N 208B1256 N515PPDog Is My Copilot Inc · Jackson, WYBuilt 2004 · S/N 208B1084 N515TWTriple M Leasing LLC · Shreveport, LABuilt 2003 · S/N 515 N5168FHallum Flying Service LLC · England, ARBuilt 1998 · S/N 502B-0520 N516NCCobra Aviation Services LLC · Oklahoma City, OKBuilt 2008 · S/N 208B2070 N516PRDepartment Of Natural & Environmental Resources · San Juan, PRS/N 208B1053 N5175BMiller Aviation Inc · Norton, KSBuilt 1998 · S/N 402B-1084 N518JJ518jj LLC · Winter Garden, FLBuilt 2001 · S/N 208B0878 N5190WMontague Aviation LLC · Inverness, MSBuilt 1999 · S/N 502B-0535 N5191BBank Of Utah Trustee · Salt Lake City, UTBuilt 1999 · S/N 402A-1094 N5192FJohnson Airspray Inc · Argyle, MNBuilt 1999 · S/N 402A-1093 N5195FRussell Charles B · Union City, TNS/N 502B-0552 N5196TCarlson Production Services LLC · Norcross, MNBuilt 1999 · S/N 502B-0556 N5197XJuliet Alpha Sierra LLC · Sartell, MNBuilt 1999 · S/N 502B-0571 N519AHComanche Maverick Air LLC · Houston, TXBuilt 1987 · S/N 519 N51RPUas Transervices Inc · Boca Raton, FLBuilt 1983 · S/N U-212 N520DGDanzer Veneer Americas Inc · Darlington, PABuilt 2001 · S/N BB-1753 N520HPHutton Mark · Denison, TXBuilt 2000 · S/N 46-97012 N5215UTwin Peaks Aviation LLC · Missoula, MTS/N 4697068 N522MKTurbines Ltd · West Point, NEBuilt 2000 · S/N 4636284 N522TGSe Express LLC · South Lyon, MIBuilt 1985 · S/N BB-1209 N522WDPegasus Air LLC · Plainville, CTBuilt 1980 · S/N 4250015 N5245FAex Aviation LLC · Davenport, FLBuilt 1965 · S/N LJ-92 N524GMTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2001 · S/N BL-142 N524GTTyler Rental Inc · Ketchikan, AKBuilt 2003 · S/N 524 N524MRMt King Air · Stevensville, MTBuilt 1979 · S/N BB524 N524PMSky Train Air LLC · Templeton, CABuilt 2000 · S/N 46-97024 N525DFBleu Cheese Aviation II LLC · Addison, TXBuilt 2000 · S/N FL-306 N526LMBentley Raymond · Elverson, PABuilt 2012 · S/N 20800544 N527CHSafeco Leasing LLC · Port Alsworth, AKBuilt 1981 · S/N BB-899 N527PBDavidson Investments LLC · Oklahoma City, OKBuilt 2003 · S/N 527 N527PKAir Care Leasing LLC · Lamar, COBuilt 1998 · S/N 402A-1067 N529AB95west Aerial Mapping LLC · Grand Forks, NDBuilt 2008 · S/N 208B2053 N529PMCarolina Express LLC · Fairmont, MNS/N 46-97029 N530HPCreek Canyon Aviation LLC · Phoenix, AZBuilt 2001 · S/N 4697101 N530WCLaboratory Corporation Of America Holdings · Burlington, NCBuilt 2003 · S/N 530 N5320NSaunders Aviation LLC · Lewes, DEBuilt 2003 · S/N 4697153 N5322DBlack Phoenix Photography LLC · Morgan Hill, CABuilt 2001 · S/N 4697074 N5322MFlight Club LLC · Erie, PABuilt 2000 · S/N 4697021

Back to AD 2014-17-08 R1