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.

N228FD228 Properties LLC · Tabernacle, NJBuilt 2023 · S/N 9115N228JASky Port Inc · Kalispell, MTBuilt 1976 · S/N 18265111N228KTTattersall Thomas K · Richmond, VABuilt 2021 · S/N 2301N228KYPapalote Ranches LLC · Missoula, MTBuilt 1978 · S/N R1722883N228LGSs228lg LLC · Middle River, MDBuilt 2007 · S/N 1780N228LRPatrose LLC · Stateline, NVBuilt 2025 · S/N 11090N228MMFly Enterprises LLC · Cumberland, WIBuilt 2005 · S/N 1335N228PLCrimmins Nathanael D · Glasgow, KYBuilt 1968 · S/N TC-1180N228QDodson International Parts Inc · Rantoul, KSBuilt 1966 · S/N D-8135N228RMitchell Warren A · Deatsville, ALBuilt 1982 · S/N 34-8233145N228RDShrader J B · Yuma, AZBuilt 1966 · S/N 310K0181N228RMSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1990 · S/N 25-1230N228RPJonesboro Cycle And Atv LLC · Bone, ARBuilt 2021 · S/N 2287N228RSRkg Enterprises · Hibbing, MNBuilt 2014 · S/N 0707N228TLSaltt Air LLC · Oakland, MDBuilt 2018 · S/N 1666N228TRDap Holdings LLC · Danbury, CTBuilt 2005 · S/N 1511N228TTT2 Contracting Inc · Fuquay Varina, NCBuilt 2023 · S/N 9314N228ZFlying Nacho Aviation LLC · Draper, UTBuilt 2021 · S/N 2241N228ZFFandrich Edward I · Payson, AZS/N 18502461N2290GHooker John L · Iowa Park, TXBuilt 1958 · S/N 51590N2290SElco Avion LLC · Eagle Lake, TXBuilt 1976 · S/N 21061233N2290XMatthews Roy E · Sparta, MIBuilt 1965 · S/N 337-0190N2292CKlein John T · Austin, ARBuilt 1953 · S/N 30592N2292GNelson Erik · Exeter, NHBuilt 1958 · S/N 51592N2292LGenzoli Steven · Hughson, CABuilt 1976 · S/N D-9947N2293FTwo Mile High Mining LLC · Victor, COBuilt 1970 · S/N 414-0097N2293GEischen Kent A · Smoot, WYBuilt 1958 · S/N 51593N2293JFrey Jerry P · Fallon, NVBuilt 1979 · S/N T18803449TN2293LLemac Aviation LLC · Mesa, AZBuilt 1976 · S/N E-971N2294CHitch Dixon S · Malta, MTBuilt 1953 · S/N 30594N2294GHenderson Ramsey H · Pittsboro, NCBuilt 1958 · S/N 51594N2294LFlying Friends LLC · Shavano Park, TXBuilt 1976 · S/N CE-676N2294XCsc Delaware Trust Co Trustee · Wilmington, DEBuilt 1965 · S/N 337-0194N2295ASemper Primus LLC · Las Vegas, NVBuilt 1969 · S/N D-9039N2295RDuhl James R · Roseville, MNFirst renewal noticeBuilt 1969 · S/N T210-0445N2295WBraswell Jerrold W · Dillingham, AKBuilt 1978 · S/N 20700448N2296DBonanza Flyers L3c · Murray, UTBuilt 1977 · S/N D-9997N2296FAttitude Aviators Inc · North Myrtle Beach, SCBuilt 1967 · S/N 310L-0096N2296LDel Air Inc · Wilmington, DEFirst renewal noticeBuilt 1976 · S/N E-932N2296RCelias Food Corp · Miami, FLS/N T210-0446N2296VGustafson Kim L · Lake Stevens, WABuilt 1968 · S/N TE-587N2298EUberoy Pawan · Pleasanton, CABuilt 1997 · S/N E3138N2298FTarheel Aviation LLC · Cherryville, NCBuilt 1967 · S/N 310L-0098N2298GPerkins Larry L · Wildomar, CAS/N 51598N2298QGalaxy Enterprises LLC · Holdrege, NEBuilt 1977 · S/N 34-7770185N2299CMiller William C · Boise, IDBuilt 1959 · S/N 52334N2299GLewis Frank B · Meeteetse, WYBuilt 1958 · S/N 51599N2299LSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1976 · S/N CE-677N2299RBaer Monte Wayne · Ronan, MTS/N T210-0449N2299TC And L Outfitters LLC · Everglades City, FLBuilt 1956 · S/N 32520
Back to AD 2000-23-21