OpenAirDocs.org
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.

N5225WAll The Way Up Aviation LLC · Valrico, FLBuilt 1962 · S/N 28-262N5225ZLamon Bruce G · Castle Rock, WABuilt 1961 · S/N 22-8901N52261Christiansen Aviation LLC · Wilmington, DEBuilt 1980 · S/N 17274465N52262Skymates Inc · Wilmington, DES/N 172S9412N52267Olds Forge Flyers Inc · Lansing, MIBuilt 1980 · S/N 17274471N5226DFargo Jet Center LLC · Fargo, NDBuilt 2008 · S/N 172S10880N5226HJockos Sleigh LLC · Fort Worth, TXBuilt 1949 · S/N 16-28N5226JMcgreen John R · Albany, NYBuilt 1980 · S/N 17273740N5226LVancura Aviation LLC · Seffner, FLBuilt 1967 · S/N 28-4520N5226MTrader Robert D · Madison, INBuilt 1978 · S/N M-2014N5226PGoodin Jacob P · Knob Noster, MOBuilt 1958 · S/N 24-256N5226WStatesboro Dental Associates Pe · Statesboro, GABuilt 1962 · S/N 28-264N5226YSale Reported · Miami, FLSale reportedBuilt 1963 · S/N 27-2275N5226ZHale Michael E · Grass Valley, CABuilt 1961 · S/N 22-8902N52271Horizon Aviation · Seneca, PABuilt 1945 · S/N 860N52272Above The Haze LLC · San Lorenzo, CABuilt 1981 · S/N 17274474N52275California Airways LLC · Hayward, CABuilt 1980 · S/N 17274475N52279Bateman Justin · Lindale, TXBuilt 1981 · S/N 17274478N5227BSasse Jonathan D · Lubbock, TXBuilt 1956 · S/N 1090N5227DTahoe Arrows LLC · South Lake Tahoe, CABuilt 1979 · S/N 17272458N5227EAce Of Spades Aviation LLC · Las Vegas, NVS/N 17271782N5227HBowman Brent W · Sebewaing, MIS/N 16-31N5227LPeter David A · Anderson, INBuilt 1967 · S/N 28-4521N5227PBranch Antonio D · Lakewood, OHBuilt 1958 · S/N 24-257N5227SDcrss LLC · Marcy, NYBuilt 2009 · S/N 18282155N5227ZPayne Robert A · Duluth, MNBuilt 1961 · S/N 22-8903N52280Southern Air LLC · Marissa, ILBuilt 1980 · S/N 17274479N52286Whitair LLC · Henderson, NVBuilt 1980 · S/N 17274482N52289Moore Daniel W · Valparaiso, INBuilt 1980 · S/N 17274483N5228EMayberry Aviation Inc · Mount Airy, NCBuilt 1978 · S/N 17271783N5228LWilliam C New Aviation Services LLC · Morgan City, LAS/N 28-4522N5228PFtf Group LLC · Galt, CABuilt 1958 · S/N 24-258N5228RMtc Leasing LLC · Sandersville, GABuilt 1974 · S/N 17263442N5228TWhytes Inc · Coconut Creek, FLBuilt 1972 · S/N 34-7250226N5228XAirbatic LLC · Huntsville, ALBuilt 1969 · S/N 206N52290Aa-Aero Inc · Fairfield, NJBuilt 1980 · S/N 17274484N5229BPisha Vincent R · Kendall, WIBuilt 1979 · S/N 15283812N5229DMiskell Christopher S · Senoia, GABuilt 1979 · S/N 17272459N5229EZak Leo P · Oakdale, PABuilt 1978 · S/N 17271784N5229HCahoon Theodore J · Erie, COBuilt 1949 · S/N 16-33N5229ROcala Aviation Services Inc · Ocala, FLBuilt 1974 · S/N 17263443N5229TParker Edward Milton Jr · Griffin, GABuilt 1972 · S/N 28R-7235002N5229WPhilips Loren K · San Diego, CABuilt 1962 · S/N 28-267N5229XG B Acro Inc · Grandville, MIBuilt 1969 · S/N 207N522ABBrandt Andrew C · Genoa, NVBuilt 2010 · S/N 91231N522AFState Of Louisiana · Baton Rouge, LABuilt 2003 · S/N 18281195N522AGHampton Roads Charter Service · Chesapeake, VABuilt 2006 · S/N 4037N522BBolster Stacey · Williamsburg, VABuilt 1956 · S/N 18-4788N522CBVancil Jon D · Collierville, TNBuilt 1960 · S/N 24-1939N522CSKarpinski Arthur A · Jordan, NYBuilt 2016 · S/N 18282422
Back to AD 81-18-04 R2