OpenAirDocs.org
AD 2000-23-21

Registered aircraft · 47,133

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.

N341BCAbeflies LLC · Montvale, NJBuilt 1972 · S/N 340-0015N341BGAttack Jack Enterprises LLC · Wilmington, DEBuilt 1973 · S/N 340-0233N341CMBc Aviation · Perham, MNBuilt 1981 · S/N 340A1255N341EYEdy Aviation LLC · Framingham, MABuilt 2017 · S/N 4571N341HCStc Aviation Inc · Saint Cloud, MNBuilt 1979 · S/N 340A0798N341JPRed Arrow Leasing Inc · Paw Paw, MIS/N 340A0293N341JSTibbs Jeffrey M · Lakewood Ranch, FLBuilt 2007 · S/N 29-0480N341MTI2i Logistics LLC · Wheeling, ILBuilt 1980 · S/N 340A0980N341PSWestern States Air LLC · Phoenix, AZS/N 29-0341N341SCShedd Aviation LLC · Columbus, INBuilt 1984 · S/N 340A1810N341SJAga Aviation LLC · Lewes, DES/N 340A0222N341TMThree For One LLC · Boulder, COBuilt 2021 · S/N 2364N341TSSecond Delaware Corp · Moorestown, NJBuilt 1955 · S/N G-773N341TVWild Hare Enterprises LLC · Valparaiso, INBuilt 1981 · S/N 340A1277N341UMedic Choppers LLC · Springdale, ARS/N TE-826N341VTBelmont Leasing LLC · Gig Harbor, WABuilt 1964 · S/N D-7589N341ZMendoza Refugio · Fresno, CABuilt 1960 · S/N D-6510N3420RBietz Jason L · Tripp, SDBuilt 1967 · S/N 18258720N3421USchuster Timothy A · Carrington, NDBuilt 1963 · S/N 18254821N3422Hergenrather Michael · Spring, TXS/N U20602920N3422LAwsm Inc · Grand Canyon, AZBuilt 1967 · S/N U206-0722N3422SLanders James F Jr · Mesa, AZBuilt 1964 · S/N 18255822N3422UK & M Aircraft LLC · Granbury, TXBuilt 1963 · S/N 18254822N3422YGumley Andrew J · Wasilla, AKS/N 18051922N3423QTrebs Adam · Tucson, AZBuilt 1977 · S/N 28R-7703108N3423SSchroeder Matt T · Riverside, CABuilt 1964 · S/N 18255823N3424RMulder Field Inc · Ivanhoe, MNS/N 18258724N3424SPickering Heavy Hauling · Fort Lupton, COBuilt 1964 · S/N 18255824N3425FJ A White & Son Aviation LLC · Powder Springs, GABuilt 1966 · S/N 18257425N3425PCw Designer Homes Inc · Burnet, TXBuilt 2001 · S/N E-3425N3425SHoulihan John D · Wasco, CABuilt 1964 · S/N 18255825N3425U4appraisals LLC · Odessa, TXS/N 18254825N3426LCurtis Jeremy A · Fairbanks, AKBuilt 1966 · S/N U206-0726N3426YMachnik Todd J · Old Lyme, CTBuilt 1968 · S/N 18051926N34271Globalsvc Aviation Group LLC · Coeur D Alene, IDBuilt 1960 · S/N 631N3427BBoyle Corey J · Robbinsville, NJBuilt 2025 · S/N 10868N3427DPowers Ryan · Boston, MABuilt 2021 · S/N 5099N3427SNovember Sierra LLC · Lake Havasu City, AZBuilt 1964 · S/N 18255827N34289Crone Steven M · Old Hickory, TNBuilt 1972 · S/N 17701754N3428FKcsi Aerial Patrol Inc · Bakersfield, CABuilt 1966 · S/N 18257428N3428UHcp Aviation LLC · Waco, TXS/N 18254828N342ACC & L Aviation LLC · Swainsboro, GABuilt 2008 · S/N 3051N342BFritz John R · Chester, MTBuilt 1957 · S/N D-4927N342CDBlanchard Aviation LLC · Waynesboro, GABuilt 2024 · S/N 9812N342DBBeitler William · Washington, PABuilt 1999 · S/N G107N342EAAfrican Inland Mission International · Peachtree City, GAS/N U20606197N342EDAviation Trust Company LLC Trustee · Oklahoma City, OKBuilt 2013 · S/N 0485N342FDCarver Mark D · Alma, GABuilt 1966 · S/N CE-101N342FSPetersen Aircraft Inc · Murdock, MNS/N 21831N342GFKites Rising LLC · Naples, FLFirst renewal noticeBuilt 2016 · S/N 4342
Back to AD 2000-23-21