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.

N55000Gross Flying Service Inc · Larned, KSBuilt 2003 · S/N 30031CN55001Eastern Stearman Inc Trustee · Leesburg, VABuilt 2003 · S/N 33002CN55007Av8 Inc · Westborough, MABuilt 1973 · S/N 28-7310106N5500CDuncan Robert L · Greenville, MSBuilt 1978 · S/N 401-78N5500EAllen Aviation LLC · Houston, TXBuilt 2001 · S/N 30026CN5500GCummings Terence J · Morgan Hill, CABuilt 1971 · S/N 17260300N5500LWinchell Lawrence R · Salem, NJBuilt 1978 · S/N 1032-78N5500MDecathlon Training Inc · Saint Louis, MOBuilt 1978 · S/N 402-78N5500UJones Donald T · Barrigada, GUS/N 28-21209N5500WKansas State University · Salina, KSBuilt 1978 · S/N 432-78N5500YMccormick Herbert L · Port Orange, FLBuilt 2001 · S/N 30027CN5500ZPfc Aviation Repair Inc · Wallingford, CTS/N 22-9286N55010Royal Aviation Academy LLC · Sarasota, FLBuilt 1973 · S/N 28-7325303N55018Stiver Roger M · Nashville, ARBuilt 1973 · S/N 28-7305291N55019Berry Kirby T · Poolville, TXBuilt 1973 · S/N 28-7305292N5501AProfly LLC · Wichita Falls, TXBuilt 1978 · S/N 360-78N5501FWade Joshua Michael · Saline, MIS/N 28-24839N5501NRoddy Warren D · Skokie, ILBuilt 1978 · S/N 1034-78N5501WTailwinds Aviation LLC · Kokomo, INBuilt 1962 · S/N 28-587N5501YBas Part Sales LLC · Greeley, COS/N 27005CN55021Robertson Alan L · Hastings, NEBuilt 1973 · S/N 28-7305294N55023Charron William H · Burwell, NEBuilt 1973 · S/N 28R-7335168N55028First Alarm Aviation LLC · Fosters, ALBuilt 1973 · S/N 28-7305295N55029Chandler William John · North Palm Beach, FLBuilt 1973 · S/N 28-7305296N5502AAero Enterprises LLC · Orange, VABuilt 1978 · S/N 408-78N5502CWebb Brad · Ekron, KYBuilt 1978 · S/N 1259-78N5502HSky View LLC · De Smet, SDS/N 1035-78N5502MRegistered aircraftBuilt 1978 · S/N 275-78N5502PBeans David W · Sharpsburg, MDBuilt 1958 · S/N 24-564N5502QAcademy Computer Services Inc · Stoneham, MABuilt 1965 · S/N 604N5502U90 Degree Crosswind LLC · Arcadia, FLBuilt 1978 · S/N 1260-78N5502WWest Kentucky Wings And Toons LLC · Benton, KYBuilt 1962 · S/N 28-589N55030Reiner John G · Wakefield, MIBuilt 1973 · S/N 28R-7335171N55031Monaghan Management Corp · Greenwood Village, COBuilt 1973 · S/N 28-7310108N55032Jacks Dean E · Madison, INBuilt 1973 · S/N 28-7310109N55033Mcneill James R · Wichita, KSBuilt 2006 · S/N 47002TN55034Osceola Aerosport LLC · Osceola, WIBuilt 1978 · S/N 420-78N5503AKey Dallas T · Hoover, ALBuilt 1978 · S/N 411-78N5503CMccreary William J · Glendale, AZBuilt 1978 · S/N 412-78N5503FN5503f Aircraft Holdings LLC · Orangeburg, SCBuilt 1968 · S/N 28-24842N5503HCp Aviation Inc · Santa Paula, CABuilt 1978 · S/N 413-78N5503JFalterman Patrick J · Cleveland, TXBuilt 1978 · S/N 414-78N5503LAnderson Firearms LLC · Montgomery, TXBuilt 1999 · S/N 25040CN5503PCore Tech Services And Supply LLC · Odessa, FLBuilt 1958 · S/N 24-565N5503QPrecious Metal Aviation LLC · Menomonee Falls, WIBuilt 1965 · S/N 2940N5503UFuller Christopher Jason · Destin, FLBuilt 1969 · S/N 28-26211N5503VPurstell Kevin D · Burnt Hills, NYBuilt 1978 · S/N 1262-78N5503YBundt Benjamin L · Montebello, CABuilt 1978 · S/N 418-78N55041Napier Clarence M · Mount Juliet, TNBuilt 1973 · S/N 28-7305297N55042Rohrbaugh Mark A · Lenexa, KSBuilt 1973 · S/N 28-7305298
Back to AD 81-18-04 R2