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.

N2131RCapriccio Leasing LLC · Tigard, ORBuilt 1964 · S/N 182-55331N2131XBrown Jerry D · Rockport, TXS/N 337-0031N2131ZAllen Travis · Newport, MEBuilt 1982 · S/N 18268165N21328Endler Harold A · Black Mountain, NCBuilt 1972 · S/N 18261563N2132FHitchcock Wayne · Shelbyville, TNBuilt 1964 · S/N U206-0332N2132LCsrh Ventures LLC · Lubbock, TXBuilt 1976 · S/N D-9923N2132RSifsof Victor G DBA · Anchorage, AKBuilt 1964 · S/N 18255332N21332Celmer Charles A · Puyallup, WABuilt 1972 · S/N 18261566N21333Melius Ray D · Erda, UTBuilt 1972 · S/N 18261567N21338N21338 LLC · Amarillo, TXBuilt 1972 · S/N 18261571N2133GPrice Bradley E · Sacramento, CAS/N 51433N2133RLewis Christopher S · Hancock, MIBuilt 1964 · S/N 18255333N2133WBeck Robert M · Bakersfield, CABuilt 1974 · S/N CE-502N21343Bulger Thomas R · Oak Harbor, WABuilt 1972 · S/N 18261575N21344Skylane Therapy LLC · Nampa, IDBuilt 1972 · S/N 18261576N21348Nri Flying Club Inc · Walnut Creek, CABuilt 1972 · S/N 18261578N2134LHeyen John M · Springfield, ILBuilt 1976 · S/N E-890N2134NPainter Christopher R · Castle Rock, COBuilt 1979 · S/N 28R-7931048N2134UDean Steel Buildings Inc · Fort Myers, FLBuilt 1982 · S/N 21064775N2134ZAvex Holdings Heli Inc · Lewes, DEBuilt 1963 · S/N 18051234N21353Elm Aviation LLC · Norfolk, VABuilt 1998 · S/N 25-2032N21358Paroulek Joseph F · Milton, DEBuilt 1972 · S/N 18261585N2135WLeary Kevin · Midland, TXBuilt 1974 · S/N D-9648N2135ZCapps Boyce Daniel · Newcastle, OKBuilt 1963 · S/N 18051235N21362Joyce James R · Bellevue, WABuilt 1972 · S/N 18261587N21368Alta Air LLC · Boise, IDBuilt 1972 · S/N 18261589N2136GCulver Deborah M · Anchorage, AKBuilt 1958 · S/N 51436N2136PTrebbow Mike A · Santa Barbara, CAS/N 28R-7931064N2136RGibbens John L Trustee · Rock Springs, WYBuilt 1964 · S/N 18255336N2136WMills Robert D · Newport, MIBuilt 1974 · S/N E-568N21370Garner Jan L · Fremont, OHBuilt 1972 · S/N 18261591N21376Vodry John · Quilcene, WABuilt 1972 · S/N 18261596N2137RFreefall Express Inc · Gardiner, NYBuilt 1964 · S/N 18255337N2137ZAnderson Kenneth L · Anchorage, AKBuilt 1963 · S/N 18051237N21382Rodriguez Carlos Mendoza · Paramount, CABuilt 1978 · S/N 34-7870434N21387Kramer Kent M · New Braunfels, TXBuilt 1967 · S/N 67-21387N2138CAv Holding Co LLC · Polson, MTBuilt 1986 · S/N 46-8608020N2138SStamm Roy Peter · Woodstock, GABuilt 1975 · S/N 21061099N2138XSpencer Douglas J · Greenwood, CABuilt 1965 · S/N 337-0038N2138ZPyle Richard B · El Paso, TXBuilt 1998 · S/N 29-0158N21393Dinelli Aviation LLC · Milton, DES/N 18261607N21395Faignant J Brian Jr · Anchorage, AKBuilt 1972 · S/N 18261608N21396Greers Banner Air Of Bakersfield Inc · Bakersfield, CABuilt 1972 · S/N 18261609N21398Peterson Peter M · Silverado, CABuilt 1977 · S/N D-10077N2139FCrow Brian M · Oakesdale, WABuilt 1965 · S/N U206-0339N2139GSoarmates LLC · Missoula, MTBuilt 1958 · S/N 51439N2139RShaw Gregory A · West Richland, WABuilt 1964 · S/N 18255339N2139XAerometrix LLC · Lino Lakes, MNBuilt 1965 · S/N 337-0039N2139ZAdkison Todd · Vinemont, ALBuilt 1979 · S/N 28R-7931160N213AGCirrus Design Corp · Duluth, MNBuilt 2026 · S/N 11548
Back to AD 2000-23-21