OpenAirDocs.org
AD 2000-23-21

Registered aircraft · 47,133

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.

N3XTHammock Jerry G · Waxahachie, TXBuilt 1970 · S/N D-9156N3XYAntique Endeavors LLC · Missoula, MTS/N 1N3YHMarsaudon David · Friday Harbor, WABuilt 2002 · S/N 0239N3YNWeaver Carl · Halstead, KSS/N 18051477N3YPAstmann Roger J · North Haven, CTBuilt 1966 · S/N CE-32N3ZEZephyr Enterprises Inc · Wilmington, DEBuilt 1968 · S/N NAV-4-2520N3ZGIsbell Tony A · Rainbow City, ALS/N 1572N3ZLN3zl LLC · Ocala, FLBuilt 2005 · S/N 1536N40001Gaines Harry E · Fontana, CABuilt 1977 · S/N 34-7770356N40007Kelleher Timothy J · Lake Placid, NYS/N 182-61875N4000DHortman Jennifer L · Murrieta, CABuilt 1958 · S/N 51361N4000JThomas Harold C · Fall River Mills, CABuilt 1960 · S/N 39134N4000LUrquhart Ken · Wedowee, ALBuilt 2013 · S/N E-4000N4000WN4000w LLC · Prescott, AZBuilt 1974 · S/N TE-1004N4001DJohnson Randall S · Craig, AKBuilt 1957 · S/N 34701N4001SLeckonby David · Waterford, NYS/N TC-1817N4001YHill James J · Saint Helen, MIBuilt 1961 · S/N 1850201N4002DVanburen Willard L Sr · Ashland, NEBuilt 1957 · S/N 34702N4002FDoyle Patrick T · Fond Du Lac, WIBuilt 1955 · S/N G-779N40036Paulay Sandor F · Kenmore, WAS/N 34-7770369N4003BHenderson James A · Flomaton, ALBuilt 1974 · S/N 75-30730N40046Ponce Annabelle S Brack · Zephyr Cove, NVBuilt 1977 · S/N 28R-7703296N4004APrice Jason R · Lillington, NCBuilt 1970 · S/N D-9098N4005DHarris Mark P · Arcata, CABuilt 1957 · S/N 34705N4005YWareham Charles L · Chugiak, AKBuilt 1962 · S/N 185-0328N40065Aldridge Raymond · Moultrie, GABuilt 1977 · S/N 28R-7703302N4006DTveitnes Svein T · Whitewright, TXBuilt 1957 · S/N 34706N4006HMcnorton Robert L · Cantonment, FLBuilt 1980 · S/N 25-0454N4007Empire Ranch Inc · Lebanon, MOFirst renewal noticeBuilt 1973 · S/N 18262208N40098Fall River County Emergency Management · Hot Springs, SDBuilt 1966 · S/N R172-0134N400APZoie Air LLC · Fort Lauderdale, FLBuilt 1974 · S/N 340-0345N400ARArh Aviation LLC · Gainesville, FLBuilt 2010 · S/N 3684N400ATAlpha Tango Aviation Inc · Middletown, DEBuilt 1981 · S/N 402C0510N400AWThomson Roy · New Castle, COS/N 41025N400BATulip Tree Hill LLC · Bloomington, INBuilt 2008 · S/N 411054N400BLBuilding Busters Demolition & Excavation Corp · Saint Louis, MOBuilt 1962 · S/N TC-319N400BUAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2008 · S/N 411047N400CAGroundloop Mafia LLC · Desha, ARBuilt 1974 · S/N TC-1727N400DMAlborn Mary L · Eagle River, AKS/N E-748N400DPLindsey Russell R · Abilene, TXS/N 310R0268N400DRKestrel Merlin LLC · Lambertville, MIBuilt 2007 · S/N 41792N400EAMdts Corp · Eden Prairie, MNBuilt 2008 · S/N 411036N400EJFletcher Development LLC · Scottsdale, AZBuilt 2016 · S/N 1245N400ENXtra Travel LLC · Ashland, ORBuilt 2002 · S/N 28N400FALifeline LLC · Jacksonville, ORBuilt 2008 · S/N 411103N400FNPb Management LLC · Montgomery, TXBuilt 2008 · S/N 411011N400GMN400gm LLC · Salisbury, MDBuilt 1974 · S/N 310Q1000N400GTDelaney Holdings LLC · De Witt, IABuilt 1971 · S/N 21059544N400HFEastern Stearman Inc Trustee · Leesburg, VABuilt 2006 · S/N 41577N400HXTevis David James · Colorado Springs, COBuilt 1964 · S/N 21058352
Back to AD 2000-23-21