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.

N32HCDrake Sr22 LLC · Franklin, NCBuilt 2021 · S/N 2420N32HGGlauser Aviation LLC · Houston, TXBuilt 1958 · S/N 461N32HWStrader John Kelly · Brenham, TXS/N 30-0003N32JGBlackbird Florida LLC · Deerfield Beach, FLBuilt 2023 · S/N 9477N32MBMarin Airmen Inc · Mill Valley, CABuilt 1969 · S/N E-160N32MCCook Tracy L · Prosper, TXBuilt 1974 · S/N 21060482N32MFHistick Logistics LLC · Camden, DEBuilt 2017 · S/N 4437N32MZRegistered aircraftS/N L2K-225N32NBSteele Kathleen N · Scottsdale, AZBuilt 1990 · S/N CE-1514N32PLDiette Paul S · Middlebury, VTBuilt 1980 · S/N 18267595N32PPDenison Aviation Inc · Atlantic, IABuilt 1964 · S/N D-7702N32PXKustatan Leasing LLC · Kenai, AKBuilt 1976 · S/N U20603343N32RLVb Glass Company Inc · Jamestown, CAS/N U20605551N32TCarolina Blue Aviation LLC · Villanova, PABuilt 1978 · S/N 18266670N32TAVan Wyk Kenneth W · Pella, IABuilt 1968 · S/N E-120N32TBBoyland Todd · Solon, OHBuilt 1980 · S/N EA-77N32TLJonesboro Cycle And Atv LLC · Bone, ARBuilt 1974 · S/N 310R0032N32VSpeer Aviation LLC · Evansville, INBuilt 1977 · S/N 340A0250N32VACommonwealth Of Virginia · Richmond, VABuilt 1974 · S/N 182-63322N32VSCraftline LLC · Delray Beach, FLS/N 340-0025N32WBFly Away LLC · Aguanga, CABuilt 2008 · S/N 3291N32WHEagle Air Partners LLC · Bartlett, TNBuilt 1977 · S/N E-1184N32ZGSky 4 Holdings LLC · Kaysville, UTBuilt 2024 · S/N 10272N32ZZJp Lemke Aviation LLC · Jenison, MIBuilt 1977 · S/N 18265469N3300AAdams Air & Sea Inc · Wilmington, DEBuilt 1969 · S/N 337-1094N3300FCarter Flygare Inc · Sacramento, CABuilt 1962 · S/N CD-443N3300GAir Amg LLC · Greensboro, NCBuilt 1977 · S/N TH-869N3300YRaulston Electric LLC · Bagwell, TXBuilt 1962 · S/N 18254300N33012Leon Hinkle LLC · Fort Ashby, WVBuilt 1975 · S/N 34-7570072N3301DJohnson Peter L · Chico, CAS/N 32099N3301RJuliet Zulu Holdings LLC · Dover, DEBuilt 1967 · S/N 18258601N3302YFoster James R · Mcpherson, KSBuilt 1962 · S/N 18254302N3303YWoolery David W Jr DBA · Lathrop, MOBuilt 1962 · S/N 18254303N3304FStephan Pamela K · Anchorage, AKBuilt 1966 · S/N 18257304N3304QMcnutt Brian K · Mojave, CAS/N 320D0104N3304XPhillips Daniel J · Argusville, NDBuilt 1967 · S/N 310L-0154N3305Erwin Matthew L · Georgetown, INBuilt 1959 · S/N 24700N3305RLivingston Sonja L · Redding, CABuilt 1967 · S/N 18258605N3305YWolfe Randall S · Wasilla, AKBuilt 1962 · S/N 18254305N3306DAlquist Kevin B · Edwardsville, KSBuilt 1955 · S/N 32104N3306QTwin G Aviation LLC · Charlotte, NCBuilt 1977 · S/N 28R-7703100N3306UMartin Paul R Jr · Greensboro, GABuilt 1963 · S/N 18254706N3306YSaunders Craig · Spring Hill, FLBuilt 1962 · S/N 18254306N33071Krogstad Bruce H · Milwaukee, WIBuilt 1975 · S/N 34-7570082N3307RPhan Tam M · Charlotte, NCBuilt 1967 · S/N 18258607N3307UPatronyk Gregory M · Santa Barbara, CABuilt 1963 · S/N 18254707N3307XMathison John M · Vancouver, WABuilt 1967 · S/N 310L-0157N3308FBravo Hotel LLC · Lewes, DES/N 18257308N3308RLocatelli Gabriel G · North Bend, ORBuilt 1967 · S/N 18258608N3308SSutton Aircraft Salvage LLC · Palmer, AKBuilt 1973 · S/N 18502267
Back to AD 2000-23-21