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.

N26630Iasco Flight Training Inc · Redding, CABuilt 1998 · S/N 17280565N2663JN2663j LLC · Rehoboth Beach, DEBuilt 1988 · S/N 0877N2663PHoffrage Michael B · Fresno, CAS/N 22-3003N2663XAvolant Aviation LLC · Mooresville, NCBuilt 1999 · S/N 17280643N2663ZVaccaro Glen J · Trinidad, COBuilt 1977 · S/N 362-78N2664AZmuda Bruce V · Eagle River, AKBuilt 1952 · S/N 18-2179N2664KPeters Jeremy D · Nampa, IDBuilt 1947 · S/N 5391N2664UHill Flying Club Inc · St George, UTBuilt 1998 · S/N 18280298N2664VKeaveny Kelly J · Annandale, MNBuilt 1974 · S/N 177RG0648N26655Weyhe Joan Monica · Medford, ORBuilt 1978 · S/N AA5A0623N2665CWindsock Skies LLC · Caldwell, TXBuilt 1978 · S/N R18200201N2665MProsser William C · Wasilla, AKBuilt 1947 · S/N 12-993N2665ZRegistered aircraftBuilt 1978 · S/N 351-78N26661Barber William M · Alden, MIBuilt 1978 · S/N AA5A0547N26664Grumman N26664 LLC · Charlotte, NCBuilt 1977 · S/N AA5A-0518N2666MBurt David R Jr · Justin, TXBuilt 1946 · S/N 12-1109N2666PBerentson Bradley J · Westhope, NDBuilt 1955 · S/N 18-4390N2666TNess Ronald O · Canyon Lake, CABuilt 1971 · S/N 28-7210002N2666ZBig Falls Flying Club Inc · Intl Falls, MNS/N 1224-78N26670Ward John L · Mexia, TXBuilt 1978 · S/N AA5A0628N26675Kilmurry Thomas · Charlotte, NCBuilt 1978 · S/N AA5A0639N26679Kennann Christopher D · Lubbock, TXS/N AA5A0641N2667WMartens Steven A · Stanley, NDBuilt 1966 · S/N 670024N2667ZHite Loren E · Fairbanks, AKBuilt 1978 · S/N 264-78N26684Stanard Paul J · Moreland Hills, OHBuilt 1978 · S/N AA5A0644N26685Le Pendu Claude E · Fruit Heights, UTBuilt 1978 · S/N AA5A0645N26688Kirker Edmund J · Omaha, NEBuilt 1978 · S/N AA5A0647N2668PRegistered aircraftBuilt 1955 · S/N 18-4392N2668TKing Thomas S · Boerne, TXBuilt 1971 · S/N 28-7205092N2668WJarchow John H · Denison, TXBuilt 1966 · S/N 993N26691Stuckenschneider Robert J · Sedona, AZBuilt 1978 · S/N AA5A0648N26693Truszkowski Donald J · Wyandotte, MIBuilt 1978 · S/N AA5A0649N26695Drude Kris A · Dayton, OHBuilt 1978 · S/N AA5A0651N26696Provincetown Pilots Group Inc · Provincetown, MABuilt 1978 · S/N AA5A0652N2669PLegends LLC · Willow, AKBuilt 1955 · S/N 18-4393N2669TCity Of Westfield · Westfield, MAS/N 28-7225082N2669WAlecci Alexander Drew · Sanford, FLBuilt 1966 · S/N 994N266AAFf22 LLC · Scottsdale, AZBuilt 2024 · S/N 2881760N266ATAirline Transport Professionals Corp Of USA · Wilmington, DEBuilt 2001 · S/N 4496104N266BBetki Randy A · Grosse Ile, MIBuilt 1958 · S/N 126N266BBJk Air LLC · Duncan, OKBuilt 1999 · S/N T20608082N266DHurricane Mesa Aviation LLC · Hurricane, UTS/N 13017N266DLCampbell Thomas J · Center, TXBuilt 2002 · S/N 25154N266FAStratus Rr LLC · New Castle, DEBuilt 2026 · S/N 28020262N266LARaintree Aviation LLC · Mesa, AZBuilt 2012 · S/N 172S11178N266LCCambridge Aviation LLC · Hillsborough, NJBuilt 1966 · S/N 30-1157N266MEGershman Randy · Marshfield, WIBuilt 2000 · S/N 18280772N266MGGeorgia Aviation Authority · Eastman, GABuilt 2020 · S/N 2881364N266PJJohnson Philip T · Waxhaw, NCBuilt 1996 · S/N 266N266SFEastern Stearman Inc Trustee · Leesburg, VABuilt 1969 · S/N 2-29
Back to AD 81-18-04 R2