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.

N246PAHugie Lucas R · Logan, UTS/N 18257487N246PCLna Flyer LLC · West Palm Beach, FLBuilt 1998 · S/N 29-0173N246PLRff Holdings LLC · Paris, MOBuilt 2023 · S/N 9219N246PTShultz L Edward · Brentwood, TNBuilt 2017 · S/N 4505N246RCeilo Aviation LLC · Miami, FLBuilt 2024 · S/N 10176N246TRegistered aircraftBuilt 1981 · S/N 18268091N246TAHartman Allen L · Queen Creek, AZBuilt 1979 · S/N 80-30977N246TDCg5t LLC · Greenwood Village, COBuilt 2013 · S/N 0674N246TJLally Glen Joseph · Pleasanton, CAS/N 0382N246TWMr Dent Inc · Manheim, PAS/N 0725N246VBSky'S The Limit Aviation LLC · Princeton, NJBuilt 2015 · S/N T24002091N246VTAkwe River Flying And Guide Service LLC · Yakutat, AKBuilt 1975 · S/N U20602822N246WBToavs Brent J · Wolf Point, MTBuilt 1969 · S/N D-8951N246WHLakehouse Aviation LLC · Peoria, ILBuilt 2019 · S/N 1982N246WTKilloran Ron · Buffalo, NDBuilt 2011 · S/N 0098N2470GBaillargeon Richard W · Springville, IABuilt 1959 · S/N 51770N2470QCities Aviation Services LLC · Dubberly, LABuilt 1966 · S/N 18257670N2471CCavjet LLC · Bonham, TXBuilt 1954 · S/N 30771N2471QThomas Salvatore J · Lenoir City, TNBuilt 1966 · S/N 18257671N2471RFykerud Eric J Sr · Bend, ORBuilt 1964 · S/N 18255571N2471TLarue Mark C · Leander, TXS/N NAV-4-2471N2472FParr Crawford B · Anchorage, AKBuilt 1966 · S/N 18051674N2472QSalzman Denise M · Cameron Park, CABuilt 1966 · S/N 18257672N2472RVac New Inc · China Village, MENon-citizen corporation, flight hours not reportedBuilt 1964 · S/N 18255572N2472XPhillips Robert Frank · Tabernacle, NJBuilt 1965 · S/N 18256372N2472YAndrews Kevin M · Riverside, CABuilt 1970 · S/N E-254N2473CLewis Eddy L · Cortez, COBuilt 1954 · S/N 30773N2473RRonald O Holcomb LLC · Lapeer, MIBuilt 1964 · S/N 18255573N2474QBurnet Aviation Group LLC · Bertram, TXBuilt 1966 · S/N 18257674N2474SEllison William K · Tipton, INBuilt 1967 · S/N 337-0774N2474TNavionic Vagabond LLC · Leesburg, VABuilt 1962 · S/N NAV42474N2474XKramer William L · Wellington, FLBuilt 1965 · S/N 18256374N2475CHansen Curtis · Merrimack, NHBuilt 1954 · S/N 30775N2475QStumpf Walter · Tulsa, OKBuilt 1966 · S/N 18257675N2475XJohnston Bruce W · Puyallup, WABuilt 1965 · S/N 18256375N2476CBrown Jack P · Anchorage, AKBuilt 1954 · S/N 30776N2476RBascom Richard J Trustee · Elkhart, IABuilt 1964 · S/N 18255576N2477GRamsey Stephen C · Aspen, COBuilt 1958 · S/N 51777N2477RJohnson Michael W · Kensington, OHBuilt 1964 · S/N 18255577N2478FSchad Paul E · Gainesville, TXBuilt 1966 · S/N 18051680N2478GGilliland Sandra K · Julian, NCBuilt 1959 · S/N 51778N2478QAbraham Curtis L · Byron, WYBuilt 1966 · S/N 18257678N2478RWeber Alan M · Manteca, CABuilt 1964 · S/N 18255578N2478XCrooked Lake Aero LLC · Hammondsport, NYBuilt 1965 · S/N 18256378N2479CTo The Wind LLC · Salmon, IDBuilt 1954 · S/N 30779N2479QPriest David E · Caldwell, IDBuilt 1966 · S/N 18257679N2479XKruse Interests LLC · League City, TXS/N 18256379N247AFlying Carpet 247 LLC · Logan, UTBuilt 2021 · S/N 2326N247AAN247aa LLC · Benton, KSBuilt 1959 · S/N D-6034N247ABFlight Insite LLC · Atlanta, GABuilt 2019 · S/N 2029
Back to AD 2000-23-21