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.

N230DWHorwich Joshua B · Santa Clara, CABuilt 1997 · S/N HB-1N230MAviation Developers Inc · Highlandville, MOBuilt 1984 · S/N U20606834N230PLudian Malgorzata · Bakersfield, CABuilt 1967 · S/N T210-0279N230QKuper Carl J II · Dalhart, TXBuilt 1966 · S/N TE-278N230SRNational Auto Solutions LLC · Gallatin, TNBuilt 2007 · S/N 2361N230SX2z West LLC · Alpine, WYBuilt 2004 · S/N 41045N230VFVictor Foxtrot LLC · Scott City, KSBuilt 2022 · S/N 8824N230WAWing Nuts Fling Club Ltd · North Chesterfield, VABuilt 2013 · S/N 2229N230WJCenter Ice Scouting LLC · Crestwood, KYBuilt 2007 · S/N 2539N2310RMccarty Brian Keith · Huntsville, TXBuilt 1964 · S/N 18255410N2310SWest Alabama Aircraft Leasing Inc · Tuscaloosa, ALS/N 337-0610N2311CB & B Aviation LLC · Wayzata, MNBuilt 1953 · S/N 30611N2311FPace Seth M · Malibu, CABuilt 1964 · S/N 21058511N2311GVan Winkle Randy M · Van Buren, MOBuilt 1959 · S/N 51611N2311VB & L Henry LLC · Chipley, FLBuilt 1997 · S/N E-3111N2312FButler Scotty · Yukon, OKBuilt 1964 · S/N 21058512N2312REagy Gregory L · Boise, IDBuilt 1964 · S/N 18255412N2312XCain James W · Big Rapids, MIBuilt 1965 · S/N 18256212N2313RBlackman David M Trustee · Pacifica, CABuilt 1964 · S/N 18255413N2314GFallang Paul Sam · Great Falls, MTBuilt 1959 · S/N 51614N2314RWilson George L · Hideaway, TXBuilt 1964 · S/N 18255414N2314XFlight Resources LLC · Monroe, GABuilt 1965 · S/N 18256214N2315CRegistered aircraftBuilt 1953 · S/N 30615N2315FRed Rock Aircraft Leasing LLC · Hurricane, UTBuilt 1964 · S/N 21058515N2315GClark Jeffrey E · Tiburon, CABuilt 1958 · S/N 51615N2315XParker Ronald Lewis · Melissa, TXBuilt 1965 · S/N 18256215N2316CTwo Wings LLC · Anchorage, AKBuilt 1953 · S/N 30616N2316FTip Of The Tusk Aviation LLC · Siloam Springs, ARBuilt 1965 · S/N 210-58516N2317SSokoloff James T · Cambridge, MAS/N E-3117N2317VMay-Collier Aviation LLC · Atlanta, GABuilt 1998 · S/N E-3164N2317XSproul Wendell C · Hermon, MEBuilt 1965 · S/N 18256217N2318ATarpley Gary H · Seaford, VABuilt 1997 · S/N E-3118N2318CWebster Robert C · East Jordan, MIBuilt 1953 · S/N 30618N2318FBe Dozer LLC · Guy, ARS/N 21058518N2318GRedmond John R · Reno, NVS/N 51618N2318RJigamian Geoffrey T · Temecula, CABuilt 1964 · S/N 18255418N2319FDelaney Patrick J · Marion, TXBuilt 1964 · S/N 21058519N2319GSkydive Co · Fairburn, GABuilt 1958 · S/N 51619N2319SHotel Whiskey Aviation LLC · San Antonio, TXBuilt 1976 · S/N 21061245N231ABEquinoxx Flight Systems LLC · Duluth, GABuilt 2020 · S/N 2090N231ACHinsdale Jeffrey M · Ionia, NYBuilt 1979 · S/N 25-0043N231AEJda Properties LLC · Stillwater, MNBuilt 1979 · S/N 25-0054N231AFPistora Steven R Trustee · Lindsborg, KSBuilt 1979 · S/N 25-0064N231AJFrimodig James P · San Diego, CABuilt 1979 · S/N 25-0082N231AKKab Flyers LLC · Greenville, ILBuilt 1979 · S/N 25-0085N231ALBaryon Aero LLC · Culver City, CABuilt 1979 · S/N 25-0089N231APHoneyland Inc · Wolf Point, MTBuilt 1979 · S/N 25-0093N231AQHenslee Christopher S · Grass Valley, CABuilt 1979 · S/N 25-0103N231ARMabry Danny W · Morehead, KYBuilt 1979 · S/N 25-0095N231ASSkousen Joel M · Spring City, UTBuilt 1979 · S/N 25-0106
Back to AD 2000-23-21