OpenAirDocs.org
AD 81-18-04 R2

Registered aircraft · 81,728

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.

N26111Career Track 5 LLC · Wilmington, DEBuilt 2026 · S/N 172S13563N26112Career Track 5 LLC · Wilmington, DEBuilt 2026 · S/N 172S13566N26114Flyinisme LLC · Saint Augustine, FLBuilt 1977 · S/N AA5A0433N26116Fasske Wayne · Crossville, TNBuilt 1977 · S/N AA5A0437N2611PRegistered aircraftBuilt 1978 · S/N 880N2611TW&H Services LLC · Boerne, TXS/N 23102CN26120Houk David A Jr · Norton, OHBuilt 1977 · S/N AA5A0441N26122Smile Givers · Chico, CABuilt 1977 · S/N AA5A0443N26124Chapman Edward J DBA · Jordan, MNBuilt 1977 · S/N AA5A0444N26127Rose David Alan · Port Orange, FLBuilt 1977 · S/N AA5A0446N2612MGreenhalgh Janna L · Caldwell, IDBuilt 1946 · S/N 12-964N2612ZStewart Jon L · Walker, MNBuilt 1977 · S/N 1002-77N26130Bokkers Maike L · Mountain View, CABuilt 1977 · S/N AA5A0447N26132Active Pilot Solutions Inc · Van Nuys, CABuilt 1975 · S/N 28-7515443N26136Aoki Nidal · Porter, TXBuilt 1977 · S/N AA5A0452N2613PBraun Daniel R · Damascus, ORS/N 22-2948N26142Stamper George William III · Quinton, VABuilt 1977 · S/N AA5A0454N2614ADixon Eric A · Salado, TXBuilt 1952 · S/N 22-896N2614DRegistration Pending · Kerrville, TXRegistration pendingBuilt 1987 · S/N 0727N2614GNorthern Air Inc · Bonners Ferry, IDBuilt 1967 · S/N 64N2614VMorris Daniel J · Bossier City, LABuilt 1974 · S/N 177RG0632N2615MKelsey Mike · Carey, IDBuilt 1946 · S/N 12-1079N2615WSturgis Joel B · Pensacola, FLBuilt 1965 · S/N 3292N26160Wilson William J · Houston, TXBuilt 1977 · S/N AA5A0455N26163Brown Michael D · Elk Grove, CABuilt 1977 · S/N AA5A0456N26165Moldt Richard W · Montrose, CAS/N AA5A0457N26167Mowery Ronnie G · Spencer, OHBuilt 1977 · S/N AA5A0461N2616ARegistration Pending · Aleknagik, AKRegistration pendingBuilt 1952 · S/N 22-895N2616WDenney David W · Fowler, COBuilt 1965 · S/N 962N26172Flying Tigers Flight School Ltd · Houston, TXBuilt 1977 · S/N AA5A0465N26179Richardson James D II · Bend, ORBuilt 1977 · S/N AA5A0468N2617MBarrett Gaston W DBA · Philadelphia, MSBuilt 1977 · S/N 32-7840051N2617QKerhulas Anthony B · Santa Maria, CABuilt 1969 · S/N 17258707N2617ZCroy Branden J · Kendallville, INBuilt 2001 · S/N 1301N2618ALevin Henry · Medford, ORS/N 22-902N2618PHenningson Terry · Centennial, COBuilt 1955 · S/N 22-2954N2619DInman Steve · Billings, MTBuilt 1952 · S/N 20771N2619PColdsmith Steven L · Chambersburg, PABuilt 1955 · S/N 22-2955N2619WSmith Cecil · Fort Pierce, FLS/N 963N261AMeridian Aircraft LLC · Wilmington, DEBuilt 2014 · S/N 2843789N261AFState Of Louisiana · Baton Rouge, LABuilt 2003 · S/N 18281186N261BWPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 28020253N261CACivil Air Patrol · Maxwell Afb, ALBuilt 2008 · S/N 18282136N261CCCook Christopher · Columbus, GABuilt 2019 · S/N 82373N261DMOelmann Dennis J · Waverly, IAS/N 379N261EPEpic Aviation Inc · Denison, TXBuilt 2026 · S/N 172S13501N261EZZokpodo Emmanuel K · Sacramento, CABuilt 1975 · S/N 28R-7635087N261FAStratus Rr LLC · New Castle, DEBuilt 2026 · S/N 28020259N261FCVu Ai · Aiea, HIBuilt 1968 · S/N 28-24697N261GTThompson Glen Maurice Jr · Wellington, FLBuilt 1999 · S/N V97050060
Back to AD 81-18-04 R2