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.

N49309Newton Thomas L Jr · Fredericksburg, VABuilt 1982 · S/N 1006N4930BSkyranch Knoxville Youth Inc · Knoxville, TNS/N 15283712N4930HSantillan Hannah M · Belgrade, MTBuilt 1948 · S/N 11-802N4930LG Salisbury & Associates Inc · Prescott, AZBuilt 1967 · S/N 28-4297N4930PRegion Flyers LLC · Valparaiso, INS/N 27-523N4930UUniversity Of Oklahoma · Norman, OKBuilt 2005 · S/N 2842241N49312Boyd Timothy · East Point, KYBuilt 1982 · S/N 1008N49314Losacker Matthew S · Chandler, AZBuilt 1983 · S/N 1014N49315Morphew Ben · Mckinney, TXS/N 1013N49319Anderson Richard P · De Leon Springs, FLBuilt 1985 · S/N 1029N4931BWojtowicz Tomasz · Bronx, NYBuilt 1979 · S/N 15283713N4931LThrust Spear Of Tampa LLC · Tampa, FLBuilt 1967 · S/N 28-4299N4931ZThurmond Kenneth · Eastover, NCS/N 22-8521N49325Qualiair LLC Trustee · MichelstadtBuilt 1985 · S/N 1031N49328Air Puerto Rico Corp · Aguadilla, PRFirst renewal noticeBuilt 1979 · S/N 15283448N4932JDunlap Aviation Inc · Dunlap, ILBuilt 1968 · S/N 28R-30653N4932SThunder Aviation LLC · Oro Valley, AZBuilt 1980 · S/N R18201471N4932ZWilczynski John J · Lake Village, INBuilt 1961 · S/N 22-8524N49330Cjw Hydrodynamics Inc · Fresno, TXBuilt 1986 · S/N 1035N49331Plane Fun Inc Tr Trustee · Snellville, GAS/N 1038N49332Blue Eagle Pitts LLC · Tempe, AZS/N 1039N49336Krieger Heinz Friedrich · FrenkendorfS/N 1045N49337Herrmann Ralf D · DahlemBuilt 1986 · S/N 1046N49338Bakker Matthew G · Ellington, CTBuilt 1986 · S/N 1044N49339Goble John H · Cresson, TXBuilt 1987 · S/N 1047N4933JRegistration Pending · Columbia, SCRegistration pending, pending cancellationBuilt 1968 · S/N 28R-30654N4933LSouthall Charles B · Amelia, OHS/N 28-4301N4933SHedden Larry H · Huntsville, ALBuilt 1980 · S/N R18201334N4933ZSale Reported · Clio, MISale reportedS/N 22-8525N49340Butler Tracey D · Buckley, WABuilt 1987 · S/N 1048N49341Dale Michael E · Murrieta, CABuilt 1979 · S/N 15283449N49343Schroeder James Conrad · Redondo Beach, CABuilt 1987 · S/N 1050N49347Bryant Otto LLC · Conway, ARBuilt 1991 · S/N 1190N49348Benner Tristen · Opheim, MTBuilt 1991 · S/N 1194N49349Rankin Ty · Amarillo, TXBuilt 1991 · S/N 1196N4934FAffordale Aviation Corp · Moriches, NYBuilt 1976 · S/N 28-7715082N4934LFlyboys LLC · Orange, VABuilt 1967 · S/N 28-4302N4934PAlm Holding LLC · Winton, CABuilt 1963 · S/N 27-527N4934SFerrell Charles A · Stockton, CABuilt 1980 · S/N R18201473N49353Skye Equipment LLC · Asheboro, NCBuilt 1992 · S/N 1217N49354Staple Three Sheep Co · Midwest, WYBuilt 1991 · S/N 1199N49357Miller Blaine Nathan · Brooks, GABuilt 1992 · S/N 1223N4935GKip'S Flying Service LLC · Bankston, ALBuilt 1979 · S/N 17273482N4935LCurnutt Aviation LLC · Fort Stockton, TXBuilt 1968 · S/N 28-5127N49362Schubert Paul · Raleigh, NCBuilt 1992 · S/N 1221N49363Back Country Aviation LLC · Kalispell, MTBuilt 1993 · S/N 1234N49365Mcdonald Ryan James · Chelan, WAS/N 1250N49366Kellogg John H · Skaneateles, NYBuilt 1994 · S/N 1257N4936LBluse James · Bethlehem, GABuilt 1967 · S/N 28-4304N4936TDakma LLC · Parma, OHBuilt 1981 · S/N R18201794
Back to AD 81-18-04 R2