Registered aircraft · 3,462

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

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 N514HBAurora Cooperative Elevator Co · Aurora, NEBuilt 2014 · S/N 502B-2978 N514LHGrowers Air Service Inc · Woodland, CABuilt 2012 · S/N 502B-2874 N514RSScherer Robert P Trustee · Aspen, COBuilt 1994 · S/N NC-51 N515ARTwin Otter International Ltd · Las Vegas, NVBuilt 1976 · S/N 515 N515CEParlueagle LLC · Montgomery, NYBuilt 2019 · S/N 100-0271 N515CTMalibu LLC · Portland, ORS/N 46-97048 N515DLDavlor Aircraft Leasing LLC · Bellefontaine, OHBuilt 2015 · S/N EVO-0060 N515TWTriple M Leasing LLC · Shreveport, LABuilt 2003 · S/N 515 N5168FHallum Flying Service LLC · England, ARBuilt 1998 · S/N 502B-0520 N516PRDepartment Of Natural & Environmental Resources · San Juan, PRS/N 208B1053 N5175BMiller Aviation Inc · Norton, KSBuilt 1998 · S/N 402B-1084 N517GMSpitfire Aviation LLC · Scottsdale, AZBuilt 1982 · S/N 395 N517SGWilmington Trust Co Trustee · Wilmington, DEBuilt 2017 · S/N 502B-3090 N517VJBank Of Utah Trustee · Salt Lake City, UTBuilt 2011 · S/N 502B-2750 N518AGKangaru Enterprises LLC · Solvang, CABuilt 2002 · S/N LJ-1671 N518JJ518jj LLC · Winter Garden, FLBuilt 2001 · S/N 208B0878 N518TSAerolease LLC · Fargo, NDBuilt 1986 · S/N LJ-1130 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 N520LASunnyside Aero Inc · Schlater, MSBuilt 2021 · S/N 502B-3293 N520SDBlue Earth Flying Service LLC · Blue Earth, MNBuilt 2014 · S/N 502B-2956 N5215UTwin Peaks Aviation LLC · Missoula, MTS/N 4697068 N521LACollinston Air Service Inc · Oak Ridge, LABuilt 2014 · S/N 502B-3011 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 N524SLCrop Dusters LLC · Maurice, IABuilt 1994 · S/N T34203DC N524SVAaa Aviation LLC · Donalsonville, GABuilt 2015 · S/N T34-438 N525DFBleu Cheese Aviation II LLC · Addison, TXBuilt 2000 · S/N FL-306 N5272TIndependent Dusting Service Inc · El Campo, TXBuilt 2022 · S/N 402B-1469 N527ATH&G Farms Inc · Corcoran, CABuilt 2022 · S/N 502B-3396 N527CHSafeco Leasing LLC · Port Alsworth, AKBuilt 1981 · S/N BB-899 N527JRRoy Avion LLC · Marksville, LABuilt 2016 · S/N EVO-0069

Back to AD 2002-23-13