OpenAirDocs.org
AD 2000-23-21

Registered aircraft · 47,138

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:2000-23-21')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2000-23-21')
  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.

N311SKDoyle Thomas Michael · New City, NYBuilt 1976 · S/N 310R0687N311TCN311tc LLC · Tacoma, WAS/N 1582N311TDWw House Inc · Lumberton, TXBuilt 2010 · S/N 3623N311TLM & N Enterprises LLC · Topeka, KSBuilt 1981 · S/N 18267937N311TNB & B Aviation LLC · Evansville, INBuilt 2006 · S/N 31-0001N311XXWeekend Pass LLC · Golden, COBuilt 2021 · S/N 2369N311ZRegistration Pending · Rockford, ILRegistration pendingBuilt 1960 · S/N CD-222N3120FLengyel Roger · Santa Fe, NMBuilt 1966 · S/N 18257220N3120MCowtown Aviation LLC · Aledo, TXBuilt 1987 · S/N CE-1204N3120QLinda In The Sky LLC · Webster, MNBuilt 1967 · S/N 18258120N3120RBulang Investments LLC · Newbury, NHS/N 18258520N3120WWiese Chuck F · Portland, ORBuilt 1973 · S/N TC-1645N3121DFrey Jerry P · Fallon, NVBuilt 1955 · S/N 31919N3121FLily Chris H · Ocala, FLBuilt 1966 · S/N 18257221N3121WAlpha Dog Aviation LLC · Marco Island, FLBuilt 1973 · S/N TH-410N3122LE C G Aviation Inc · Orange, CABuilt 1965 · S/N 310J0122N3122MMiller-Jackson Co Inc · Oklahoma City, OKBuilt 1984 · S/N EA-416N3122RMarrow Henry G · Southern Pines, NCBuilt 1994 · S/N TH-1722N3122STecumseh Skydiving School LLC · Tecumseh, MIBuilt 1964 · S/N 18255622N3122UTravel Aviation Inc · Vineyard Haven, MABuilt 1988 · S/N E-2431N3122YJti Management LLC · Colfax, WAS/N 18254122N3123CRmc Aviators LLC · Wilmington, DEFirst renewal noticeBuilt 1954 · S/N 30922N3123QDarkhorse Six Inc · Boerne, TXBuilt 1967 · S/N 18258123N3123RHs Aviation Holdings LLC · Eagle, IDBuilt 1967 · S/N 18258523N3123SGabin LLC · Tulsa, OKBuilt 1964 · S/N 18255623N3123WSullivan Dan · Kingwood, TXBuilt 1973 · S/N E-500N3123YAbecca Corporation · Jackson, MIBuilt 1962 · S/N 18254123N3124DBurch David C · Flushing, MIBuilt 1955 · S/N 31922N3124FTrue Aviators LLC · Kiowa, KSBuilt 1966 · S/N 18257224N3124RMidland Liberty LLC · Midland, MIBuilt 1967 · S/N 18258524N3124WBaron 24w LLC · Outing, MNBuilt 1973 · S/N TH-411N3125DDavis Ronald L Jr · Soldotna, AKBuilt 1955 · S/N 31923N3125FHall Aircraft LLC · Kenai, AKS/N 18257225N3125LOxley Lake Solutions LLC · Lawton, MIBuilt 1965 · S/N 310J0125N3125QSunrise Aviation Llp · Gig Harbor, WABuilt 1967 · S/N 18258125N3125WRowe Benjamin Stratton · Nome, AKBuilt 1959 · S/N 50584N3125YOberdoerster Timothy L · Concord Township, OHS/N 18254125N3126CWest Leland Dan · Elverta, CAS/N 30925N3126DMyers Martin John Trustee · Juneau, AKBuilt 1955 · S/N 31924N3126YOutdoor Freedom Inc · Camdenton, MOBuilt 1962 · S/N 18254126N3127CChaar LLC · Lock Haven, PAS/N 30926N3127DE & S Group LLC DBA · Columbia, CABuilt 1955 · S/N 31925N3127EAllison John W Jr · Brighton, COBuilt 1953 · S/N 30087N3127FN3127f Aviation LLC · Charlotte, NCBuilt 1966 · S/N 18257227N3127LContainer Stop Inc · Paso Robles, CABuilt 1965 · S/N 310J0127N3127WWalkcon Holdings LLC · Amarillo, TXBuilt 1988 · S/N E-2433N3128DCopsey Harvey J · Tucson, AZBuilt 1955 · S/N 31926N3128FSwartzendruber Rodney S · Bay Port, MIBuilt 1966 · S/N 18257228N3128QK Bell Enterprises Inc · Columbia Falls, MTBuilt 1967 · S/N 18258128N3128RHuelsmann Gayle M · Albuquerque, NMBuilt 1967 · S/N 18258528
Back to AD 2000-23-21