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.

N6400PRiegel Frederick E · Houston, OHBuilt 1959 · S/N 24-1510N6400QHillsboro Aero Academy LLC · Hillsboro, ORBuilt 1981 · S/N 15285244N6400SRegistration Pending · Salida, CORegistration pendingBuilt 1999 · S/N 4272/218N6400UAudetat Thomas Jr · Marana, AZBuilt 1962 · S/N 2147N6400VFearon Kenneth M · Sidney, OHBuilt 1980 · S/N 172RG0662N6400WRegistration Pending · Los Osos, CARegistration pendingBuilt 1964 · S/N 28-20468N6400YAztec Flyers LLC · Zephyrhills, FLBuilt 1967 · S/N 27-3685N64012Jin Jin Aviation LLC · Anchorage, AKBuilt 1981 · S/N 17275505N64014Maynor Robert B · Mansfield, LABuilt 1975 · S/N 17264961N64016Ponderosa Aviators LLC · Baker, MTBuilt 1975 · S/N 17264963N64017Pilots Today Inc · Berlin, MDBuilt 1975 · S/N 17264964N6401JMccarthy J Patrick · Pleasanton, CABuilt 1968 · S/N 28-4817N6401QHunter Donald J · Scottsdale, AZBuilt 1967 · S/N 670141N6401RNorthern Prairie Sky LLC · Erskine, MNBuilt 1966 · S/N 28-21579N6401UBlue Sky Aviation Adventures LLC · St George, UTS/N 2148N6401VGdl Aviation LLC · Lincoln, NEBuilt 1980 · S/N 172RG0663N64020Bend Aircraft Mechanics LLC · Bend, ORBuilt 1975 · S/N 17264966N64023Rawson Aviation LLC · Collinsville, OKBuilt 1975 · S/N 17264969N64027Snyder Brent R · Dallas, TXBuilt 1985 · S/N R18202021N6402LHarsh Kevin R · La Junta, COBuilt 1972 · S/N AA1A-0402N6402QMooney Mooney Mooney LLC · Gig Harbor, WABuilt 1967 · S/N 670142N6402UMccleave Thomas · Everett, WABuilt 1962 · S/N 2149N6402VG&M Aircraft Inc · Wheat Ridge, COBuilt 1980 · S/N 172RG0664N64034State Of Louisiana · Baton Rouge, LABuilt 1981 · S/N 17275507N64035Loomis Darwin · Mooreland, OKBuilt 1975 · S/N 17264980N6403EGultch Dale R · Brookfield, WIBuilt 1959 · S/N 46503N6403JDog House Aviation LLC · Houston, TXBuilt 1968 · S/N 28-4819N6403MPlane N Simple Aviation LLC · Los Angeles, CABuilt 1980 · S/N 15284711N6403PDiemand Larry L · Mentor, OHBuilt 1959 · S/N 24-1513N6403QMiller Fred J · Sahuarita, AZBuilt 1967 · S/N 670143N6403VVista Aviation Inc · Pacoima, CABuilt 1980 · S/N 172RG0665N6403WDanford Scott M · Chickamauga, GAS/N 28-20471N64040Golding Donald J · Tucson, AZBuilt 1981 · S/N 17275509N64043Aira Aviation LLC · Grand Ledge, MIFirst renewal noticeBuilt 1975 · S/N 17264981N64045Walker Robert · Chula Vista, CABuilt 1975 · S/N 17264983N64046Biesecker Michael Gary · High Point, NCBuilt 1975 · S/N 17264984N64048Gray Peter A · Salinas, CABuilt 1975 · S/N 17264986N6404JMorgan Donelle C · Cambria, CABuilt 1968 · S/N 28-4820N6404PNickell Paul D · Milo, IABuilt 1959 · S/N 24-1514N6404UPhiyawa Airplane Holding Inc · Argyle, TXBuilt 1962 · S/N 2151N64053Collins Thomas A · Orleans, MABuilt 1975 · S/N 17264990N64056Angel Aviation Inc · Peoria, AZBuilt 1981 · S/N 17275512N6405JTubesing Gordon Earl Trustee · Palm Coast, FLBuilt 1968 · S/N 28-4821N6405LKoster Mark W · Amarillo, TXBuilt 1972 · S/N AA1A-0405N6405PSundstrom Raymond C · Ottawa, KSBuilt 1959 · S/N 24-1515N6405WNightline Air LLC · Saratoga Springs, UTBuilt 1964 · S/N 28-20473N64061Stark Glenn M · Nampa, IDBuilt 1975 · S/N 17264994N64062M G Enterprises Of Albert Lea Inc · Alden, MNBuilt 1975 · S/N 17264995N64063Bowers Alan B · Bellevue, WABuilt 1975 · S/N 17264996N64065Lg Holdings LLC · Gretna, NES/N 17275514
Back to AD 81-18-04 R2