Registered aircraft · 3,126

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:2016-05-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:2016-05-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:2016-05-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:2016-05-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:2016-05-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:2016-05-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.

N509ZPNeal Aircraft Inc · Slaton, TXBuilt 2021 · S/N 802A-0931 N50BRBartholow Rental Company Inc · Wylie, TXBuilt 2001 · S/N LJ-1632 N50FKFirecracker Inc · Eugene, ORBuilt 1984 · S/N 006 N50GGN50gg Leasing LLC · Ponca City, OKBuilt 2000 · S/N BB-1728 N50KAKenmore Air Harbor LLC · Kenmore, WABuilt 1956 · S/N 221 N50NABv Transportation LLC · Portland, ORBuilt 1995 · S/N BB1504 N5100DTall Towers Aviation Inc · Page, NDBuilt 1997 · S/N 502B0412 N51019Lohmann Jack R · Frisco, COBuilt 2000 · S/N 4697008 N5102AThrush Aircraft LLC · Albany, GABuilt 2020 · S/N T34-503 N51080Flying Rhino Aviation Ltd · Alliance, NEBuilt 2020 · S/N T660-158DC N5109HAlexander Ag Flying Service Inc · Walnut Grove, CABuilt 1997 · S/N 502B-0460 N510GSAmdel Holding LLC · Houston, TXBuilt 2001 · S/N BB-1746 N5110SChoctaw Flying Service Inc · Inverness, MSBuilt 1997 · S/N 402A-1043 N5110ZPonderosa Airtankers LLC · Safford, AZBuilt 1998 · S/N 802A-0060 N5111PDe La Vega Artemio · Dallas, TXBuilt 1986 · S/N LJ-1136 N5119CEmpty Pockets Flying Service Inc · Wilson, ARBuilt 2019 · S/N T660-143 N5119GTri-Air Farms LLC · Mamou, LABuilt 1997 · S/N 502B-0474 N511KVDelta Fox LLC · Woodland, CABuilt 1995 · S/N LJ1422 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 N512LAWestern Pilot Service Inc · League City, TXBuilt 2009 · S/N 802A-0312 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 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 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 N519CKAgwerx Aviation Inc · Yuma, COBuilt 2025 · S/N 802A-1183 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 N521BFBs Flying Service LLC · Middletown, DEBuilt 2020 · S/N 602-1313 N522BFBs Flying Service LLC · Middletown, DEBuilt 2022 · S/N 602-1333 N522LAWallin Michael · Walnut Ridge, ARBuilt 2015 · S/N 802A-0622

Back to AD 2016-05-13