AD 81-18-04 R2

Registered aircraft · 81,733

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

N5654PLiebrecht Dennis L DBA · Ocala, FLBuilt 1959 · S/N 24-725N5654SWilcox Ryan · Brookland, ARBuilt 1966 · S/N MA-80N5654URoss Michael M Trustee · Anchorage, AKBuilt 1984 · S/N 8043CN5654VHodges Tandi R · The Woodlands, TXBuilt 1977 · S/N 28-7716190N5654WHaymes Will · Knoxville, TNBuilt 1962 · S/N 28-815N5655Phillips Mark E · Williamsville, ILS/N 28-3720N56550Holmes Peter L · Erieville, NYBuilt 1984 · S/N 8056CN56557Mannering Robert D · Warrensburg, MOS/N 11002CN56558Onlyfly LLC · Deltona, FLS/N 28-7425004N56559Waggoner Gregory · Woodward, OKBuilt 1973 · S/N 28-7405017N5655HRansdell Elise A · Springfield, ILBuilt 1947 · S/N 16-266N5655JSale Reported · New Underwood, SDSale reported, pending cancellationBuilt 1984 · S/N 7462CN5655PRegistration Pending · Parkland, FLRegistration pendingBuilt 1984 · S/N 10003CN5655QJamil Mohammad Mahbub · Stockton, CABuilt 1965 · S/N 3026N5655RKavalieros James A · Bridgewater, NJBuilt 1984 · S/N 8049CN5655ZTroth Gary D · Mound City, KSBuilt 1962 · S/N 22-9478N5656BBryant David L · Glendale, ORBuilt 1983 · S/N 4002CN5656EN2893e LLC · Reno, NVBuilt 1978 · S/N 17271913N5656HCaldwell Joel · Galveston, TXS/N 16-267N5656PTaylor National Transportation LLC · Palatine, ILBuilt 1959 · S/N 24-727N5656SAnderson Nathan A · Soldotna, AKBuilt 1984 · S/N 4006CN5656WBennett Steven D · Durham, NCS/N 28-821N5656YD & D Airpark LLC · Anchorage, AKBuilt 1965 · S/N 18-8290N5657Woods Donald E · Great Falls, MTBuilt 1974 · S/N 4426N56573Knuth Matthew · Waupaca, WIBuilt 1973 · S/N 28-7405019N56578Somerset Air Service Inc · Bedminster, NJBuilt 1973 · S/N 28-7325661N5657ADaily John F · Chugiak, AKBuilt 1984 · S/N 4013CN5657LSkyray LLC · Sugar Land, TXBuilt 1969 · S/N AA1-0057N5657QRegistration Pending · Phoenix, AZRegistration pendingBuilt 1965 · S/N 3027N5657RFord Darryl · Caldwell, IDBuilt 1965 · S/N 17253287N5657SMelton Ricky N · Luttrell, TNBuilt 1984 · S/N 8054CN5657WMacdonald Kenneth A · Willow, AKBuilt 1962 · S/N 28-822N56580Young Robert L Trustee · Ashland, OHBuilt 1973 · S/N 287325662N56584Pathfinder Air Inc · Troy, MIBuilt 1973 · S/N 28-7410012N5658KKapp Jerry · Phoenix, AZBuilt 1985 · S/N 10007CN5658LBores Scott J · Huron, OHS/N AA1-0058N5658UTully James W · Clarksville, TNBuilt 1969 · S/N 28-26454N5658VN5658v Aviation LLC · Huntsville, TXBuilt 1977 · S/N 28R-7737067N56591Williams Anthony S · Miramar, FLBuilt 1973 · S/N 28-7325664N56592Clw Aviation LLC · Springville, ALBuilt 1973 · S/N 28-7325665N56596Gutowski Michael H · Westfield, MABuilt 1973 · S/N 28-7405021N56598Avalos Alberto Hernandez Jr · Detroit, MIBuilt 1973 · S/N 28R-7435016N5659HVarnold Paul M · Pilesgrove, NJBuilt 1985 · S/N 11003CN5659QKlempel Reuel David · Eltopia, WAS/N 3028N5659RBeckham Kyle J · Wasilla, AKBuilt 1985 · S/N 8062CN5659TMorgan Peter Thomas · Bellingham, WABuilt 1964 · S/N 17251559N5659WLeon James M · Frankfort, ILBuilt 1962 · S/N 28-826N565ADPhoenix East Aviation LLC · Daytona Beach, FLBuilt 2005 · S/N 172S9991N565CHTextron Aviation Employees Flying Club Inc · Wichita, KSBuilt 2026 · S/N 172S13493N565EREmbry-Riddle Aeronautical University Inc · Prescott, AZBuilt 2022 · S/N 172S12877
Back to AD 81-18-04 R2