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.

N352SRGulf Atlantic Airways Inc · Gainesville, FLBuilt 2006 · S/N 2030N352TImpact Aviation LLC · Ballwin, MOBuilt 1973 · S/N 340-0227N352TBJdc Aviation LLC · Gainesville, FLS/N E-4132N352TSBoss Contract Services LLC · Terry, MTBuilt 1972 · S/N 414-0352N352WTTinkerbell Holdings LLC · Tavares, FLBuilt 2010 · S/N 0005N352XRuach Ministry · Dover, DEBuilt 1976 · S/N 6158CN353Giddings Thomas C · Fort Myers, FLBuilt 1999 · S/N AT-7N3530FHeames Scott D · Simi Valley, CABuilt 1967 · S/N 18258030N3530UKalmbach Justin J · Polson, MTBuilt 1963 · S/N 18254930N3530YScollon Brian F · Hudson, COFirst renewal noticeBuilt 1962 · S/N 18254430N3531Lippert Mark S · Collinsville, OKBuilt 1970 · S/N 198N3531YPetter David · Stuttgart, ARBuilt 1962 · S/N 18254431N3532AGuedon Aviation LLC · Natchez, MSBuilt 1969 · S/N CE-289N3532LPiab Inc DBA · Fresno, CAS/N 18254932N3533YFarley Sean D · Anchorage, AKBuilt 1962 · S/N 18254433N3534FLackie Paul C · Melbourne, FLBuilt 1966 · S/N 18257534N3534QLeatherneck Aviation LLC · Billings, MTBuilt 1969 · S/N 188-0484N3535RMannion Paul R · Mentor, OHBuilt 2008 · S/N 29-0502N3537FWatson James L · Burke, VABuilt 1966 · S/N 18257537N3537YCaton Robert M · Stafford, VABuilt 1963 · S/N 18254437N3538FGospel Ministries International Inc · Collegedale, TNBuilt 1966 · S/N 18257538N3538UVan Bilsen Aero LLC · Boise, IDBuilt 1963 · S/N 18254938N353BBlair Aircraft No 2 LLC · Herriman, UTBuilt 1957 · S/N D-4971N353BC5101 LLC · Granville, OHBuilt 2002 · S/N 1172N353CAAvpal Aviation LLC · Cupertino, CABuilt 2011 · S/N 2088N353CDSt Croix Leasing LLC · Fredonia, WIBuilt 2004 · S/N 1210N353DCulver Marc D · Anchorage, AKBuilt 1956 · S/N 35353N353EEBruce Douglas E · Desmet, IDBuilt 1976 · S/N 18503150N353GGrady Seamus Trustee · Pleasanton, CABuilt 2026 · S/N 11136N353KSReichard Leasing LLC · Harrisburg, PABuilt 2024 · S/N 10212N353LABas Part Sales LLC · Greeley, COBuilt 1970 · S/N TC-1339N353PGDecarlo Rick P · Minden, NVBuilt 2004 · S/N 1115N353RSecond Time Around Lt LLC · Corona, CAS/N D-10209N353TCook Thedra K · Peachtree City, GABuilt 2006 · S/N LIV 293N353TCFsh Escrow Corp · Galveston, TXBuilt 2011 · S/N LIV-426N3540FMcevoy Rex · Custer, SDS/N 18257540N3540YAero Leasing LLC · Rapid City, SDBuilt 1962 · S/N 18254440N3542UChristensen Paul · Granite Falls, WABuilt 1963 · S/N 18254942N3542YNash Richard P · Missoula, MTBuilt 1962 · S/N 18254442N3543FKorngold Brandon L · Aliso Viejo, CABuilt 1966 · S/N 18257543N3543MConnor Michael B · Antioch, TNBuilt 1978 · S/N 28R-7803176N35443Registered aircraftBuilt 1973 · S/N 21059992N3544FFercho Corliss Y · Glendive, MTBuilt 1966 · S/N 18257544N3544UKarmik Aviation LLC · Fort Edward, NYS/N 18254944N3544YPeters Ben · Seminole, TXBuilt 1962 · S/N 18254444N3546FN3546f LLC · Kitty Hawk, NCBuilt 1966 · S/N 18257546N3547UPanhandle Aviation LLC · Thatcher, AZBuilt 1963 · S/N 18254947N3547YS & W Aviation LLC · Saint Peters, MOBuilt 1962 · S/N 18254447N35498Ray Arthur G · Springdale, ARBuilt 1973 · S/N 21059996N3549UKimble Bryant Shane · Hinton, OKS/N 18254949
Back to AD 2000-23-21