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.

N61808Cape Island Aviation LLC · Millville, NJBuilt 2008 · S/N 172S10709N6180LAryvue Inc · Cordele, GABuilt 1972 · S/N AA5-0280N6180TInternational Air Services Inc Trustee · Carson City, NVS/N 172S12389N6180WChristiansen Aviation LLC · Wilmington, DEBuilt 2008 · S/N 172S10706N6180XLewis University · Romeoville, ILBuilt 2008 · S/N 172S10707N6180ZZeliff Aviation LLC · Batavia, NYS/N 831-72N61812Craft Robert L · Cynthiana, KYBuilt 1975 · S/N 17264818N61813Nationwide Aviation LLC · Hudson Oak, TXBuilt 1975 · S/N 17264819N61814On Glideslope LLC · Middletown, DEBuilt 1975 · S/N 17264820N61817Rb Aviation LLC · Vassar, MIBuilt 1975 · S/N 17264821N6181DNolta Christopher D · Corcoran, CABuilt 1957 · S/N 18-5468N6181FTarchinski James E · Rochester Hills, MIBuilt 1979 · S/N 17273161N6181PLowe David M · Sacramento, KYBuilt 1959 · S/N 24-1283N6181RTrahan Gregory M · Rayne, LABuilt 1979 · S/N 172RG0106N6181TFree Theta Aeronauctics LLC · Sacramento, CAS/N R18201929N61822Wings Over Texas Holdings LLC · Denton, TXBuilt 1975 · S/N 17264822N61825Prestage Michael J · Hondo, TXBuilt 1975 · S/N 17264824N6182DGr8daynevada LLC · Carson City, NVBuilt 1957 · S/N 18-5469N6182FAllsouth Aviation LLC · Buford, GABuilt 2008 · S/N 18282079N6182LHansen Karl G · Waxahachie, TXBuilt 1970 · S/N AA1-0382N6182UEfi Aviation LLC · Wilmington, DEBuilt 2008 · S/N 18282080N6182WBarrette Jason W · Mandeville, LAS/N 28-20205N6183Golden Age Air Museum · Bethel, PABuilt 2012 · S/N GA6183N61832Prop Wash Aero Inc · Senoia, GABuilt 1975 · S/N 17264828N61834Offerman Leo · Emily, MNBuilt 1975 · S/N 17264829N61835Epic Aviation Leasing LLC · Puyallup, WAS/N 17264830N61837Park Richard J · Devol, OKBuilt 1975 · S/N 17264831N61839Fixen Jimmie Trustee · Lynd, MNBuilt 1975 · S/N 17264833N6183LPittsburgh Institute Of Aeronautics · West Mifflin, PAS/N AA1-0383N6183SFarm Air LLC · Gridley, CABuilt 2004 · S/N 18281389N6183VCripe Rodney J · Middlebury, INBuilt 1977 · S/N 836N6183WMartin Neal O · Reno, NVS/N 28-20207N6183XCanipe Kendall L · Shelby, NCBuilt 1981 · S/N M-2350N61840Jimenez Cruz Juan C · Mayaguez, PRS/N 17264834N61841Burggraf Sean Hj · Grand Rapids, MNS/N 17264835N61842Skywalker Flight Schoool LLC · Adrian, MIBuilt 1975 · S/N 17264836N6184JInverted Holdings LLC · Newnan, GABuilt 1976 · S/N 28-7615324N6184PCollins Michael J · Chandler, AZBuilt 1959 · S/N 24-1286N61852Knight-Graham Michael L Trustee · Truckee, CABuilt 1975 · S/N 17264844N61856Paraclete Sky Adventures LLC · Raeford, NCBuilt 1975 · S/N 17264847N61859Jprg Aviation Inc · Orlando, FLBuilt 1975 · S/N 17264849N6185DOmega 1 Corp · Middletown, DEBuilt 1957 · S/N 18-5474N6185HSargent Patrick S · Bicknell, INBuilt 1977 · S/N 28-7890215N6185JYankee Pilots Inc · Haverhill, MABuilt 1976 · S/N 28-7615325N6185RSkywalker Ranch LLC · Dover, DEBuilt 1979 · S/N 172RG0108N6185UMustang Sally Aviation LLC · Camden, SCBuilt 2008 · S/N 172S10719N61866Wings Over Texas Holdings LLC · Denton, TXBuilt 1975 · S/N 17264852N61868Jamm Aircraft LLC · Sterling, OHBuilt 1975 · S/N 17264854N6186JRegistration Pending · Sebastian, FLRegistration pendingBuilt 1976 · S/N 28-7615326N6186TAtlas Aviation Tampa Inc · Tampa, FLBuilt 2008 · S/N 172S10729
Back to AD 81-18-04 R2