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.

N3317RBanti Gustavo · Marco Island, FLBuilt 1967 · S/N 18258617N3317USierra Aviation LLC · Fond Du Lac, WIBuilt 1963 · S/N 18254717N33189Schrage Rodney L · Steamboat Springs, COBuilt 1975 · S/N U20602659N3318FIsland Aero LLC · Tavernier, FLBuilt 1966 · S/N 18257318N3318Q2400 Rickenbacker LLC DBA · Auburn, CABuilt 1966 · S/N 320D0118N3318RPetersen Family 1999 LLC · Anchorage, AKS/N 18502872N33196One Niner Six Aviation LLC · Anchorage, AKBuilt 1975 · S/N U20602664N3319JWelch Cooper · Lee, FLBuilt 1980 · S/N 18803627N3319QNeuschaefer George H · White Hills, AZBuilt 1966 · S/N 320D0119N331APSugar Creek Partners LLC · Rogers, ARBuilt 2021 · S/N 5109N331BXFay Craig J · Fairfax Station, VABuilt 1967 · S/N 310L-0168N331CBN331cb LLC · Great Falls, MTBuilt 1979 · S/N 21063747N331CSBauer Matthias · Ann Arbor, MIS/N D-7126N331DFDc-3 Pro Services LLC · Hailey, IDBuilt 1961 · S/N 185-0164N331DPAguayo Domingo · Marco Island, FLBuilt 1965 · S/N CD-954N331EBEberly Mark H · Carmel, INBuilt 1976 · S/N CE-651N331EDDaniel Dunagan Inc · Rome, GABuilt 2017 · S/N 4544N331HKCharter Scott R · Manistique, MIBuilt 1960 · S/N D-6313N331JGLeone Richard · Edwards, MSS/N 1627N331JTJuliet Tango Flying Services LLC · Walnut Creek, CABuilt 1972 · S/N 18501899N331KKK&K Aviation LLC · Anthem, AZBuilt 2017 · S/N 1486N331KWHeritage Academy Inc · Monterey, TNBuilt 1963 · S/N 3360026N331LMIslandflight Co · Wilmington, DEBuilt 1999 · S/N 3449137N331LSTechnical Education Services Inc · Virginia Beach, VABuilt 1969 · S/N 310Q0028N331RHWhite Wing Aviation LLC · Shreveport, LABuilt 1977 · S/N CE-691N331SMApex Aviation LLC · Farmingdale, NYBuilt 2018 · S/N 4630N331SPReinfeldt Phillip R · Burnsville, MNS/N 18268441N331STFoothill Fire Protection Inc · Loomis, CABuilt 2024 · S/N 9770N331TFCapital Holdings 244 LLC · Dover, DEBuilt 2024 · S/N 10133N331VRaptor Airmotive LLC · Poplar Grove, ILBuilt 1978 · S/N 347870340N331WGRegistration Pending · York, PARegistration pendingBuilt 2026 · S/N 11509N331WPFms Management System LLC · Dover, DES/N 1718N331WVDeaver John · Waco, TXBuilt 2019 · S/N 1893N3320DPara Tactics LLC · Shelton, WAS/N 32118N3320FPoock Jerry D · Spencer, IABuilt 1966 · S/N 18257320N33216Avarts LLC · New Castle, DES/N U20602676N3321CAviation Management II LLC · Des Moines, IAS/N E-1261N3321FOwl Aviation LLC · Kingsport, TNBuilt 1966 · S/N 18257321N3321MMaxray Aviation LLC · Ashland, OHBuilt 1978 · S/N 310R1343N3321RGray Kerry L · Granbury, TXBuilt 1967 · S/N 18258621N3321XPatton Aviation LLC · Billings, MTS/N 310L-0171N3322DObrien Aviation LLC · Moreno Valley, CABuilt 1955 · S/N 32120N3322FCrystalline Entity · Los Angeles, CABuilt 1966 · S/N 18257322N3322UPrecision Design Inc · Wilimington, DEBuilt 1963 · S/N 18254722N3322XAllgood Michael K · Saint Augustine, FLBuilt 1974 · S/N 310Q1030N3322YFostair Inc · Ovid, NYS/N 18254322N3323DPrince Christopher E · Anchorage, AKBuilt 1955 · S/N 32121N3323FFly The Dream LLC · Sun Prairie, WIBuilt 1966 · S/N 18257323N3323RD&J Air Adventures Inc · Koloa, HIBuilt 1967 · S/N 18258623N3323YMiellerie LLC · Bridgeport, TXBuilt 1962 · S/N 18254323
Back to AD 2000-23-21