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.

N23PRTaunton Skies LLC · Dover, DEBuilt 2008 · S/N TH-2243N23RGRogers Ralph R · Winifred, MTBuilt 1964 · S/N 185-0693N23RHCajun Crimson Air LLC · Hoover, ALS/N 414A0258N23RMMurray Michael G · Olathe, KSBuilt 1964 · S/N D-7311N23SBCirrus Life LLC · Boise, IDBuilt 2019 · S/N 2045N23SFTarhanick Timothy P · Livonia, MIBuilt 1971 · S/N 21059547N23SJRatnikov Dmitry · Jay, NYBuilt 1981 · S/N EA-222N23THLudlow Christopher C · Redding, CABuilt 1966 · S/N CD-1019N23TPKarel Benjamin · Stillwater, MNS/N CE-870N23USCentral Coast Aviation Medical Examiners LLC · Monterey, CABuilt 2024 · S/N 10108N23VVRoberts Daniel L · Westerville, OHBuilt 1990 · S/N CE1490N23WHM Hixson Aviation LLC · Lake Dallas, TXBuilt 2026 · S/N 11356N23WRCraft Enterprises IV LLC · Beavercreek, OHBuilt 1981 · S/N E-1827N23XGUsda Forest Service Fepp · Malvern, ARBuilt 1967 · S/N R1720163N23XUTwo Three Xray Uniform LLC · Overland Park, KSBuilt 2022 · S/N 8633N23ZAValiair Lc Trustee · Casper, WYBuilt 2025 · S/N 10886N2400CFloyd William W · Anchorage, AKBuilt 1954 · S/N 30700N2400GN2400g LLC · Fredericksburg, VAS/N T24002137N2400QGc10 Aero LLC · Birmingham, ALBuilt 1966 · S/N 18257600N2400RJenkins Clayton S · Brock, TXBuilt 1964 · S/N 18255500N24012Grubba Gregory T · Anchorage, AKBuilt 1974 · S/N U206-02237N2401GKidd Alexander P · Nashville, TNBuilt 1958 · S/N 51701N2401RSky182 LLC · Eugene, ORS/N 18255501N2401TRempert Randel L · Antioch, ILBuilt 1962 · S/N NAV-4-2401N2402ALaurelton Village Inc · Alamance, NCS/N TC-1931N2402RSmith Porter Allen · Aztec, NMBuilt 1964 · S/N 18255502N2402TMoehling Richard Lee · Cleveland, OKBuilt 1962 · S/N NAV-4-2402N2402XTeeter Ralph R · Caldwell, IDS/N 18256302N2403BDmm Airshows LLC · Wilmington, DEBuilt 1949 · S/N 3703N2403GZeus Air Inc · Wilmington, DEBuilt 1958 · S/N 51703N2403QSkydive Harbor Springs Inc · Charlevoix, MIBuilt 1966 · S/N 18257603N2403RDuck Dennis H · Jefferson City, TNBuilt 1964 · S/N 18255503N2404CWatts Noah D · San Antonio, TXS/N 30704N2404FDe Vries James S · Pacific, MOS/N 18051604N2404QHoch Lance M · New Plymouth, IDFirst renewal noticeBuilt 1966 · S/N 18257604N2404ZSutherland Kurt Aron · Valley View, TXBuilt 1981 · S/N 18267897N2405GWarren Sam A Jr · Stanwood, WABuilt 1959 · S/N 51705N2406CRopps Spraying Service Inc · Pasco, WABuilt 1954 · S/N 30706N2406QSteely John R · Anderson, SCBuilt 1966 · S/N 18257606N2406RSale Reported · Lincoln, NESale reportedBuilt 1964 · S/N 18255506N2406TThibault William K · Colonial Heights, VAS/N NAV-4-2406N2407GFaull James Aldo · Boise, IDBuilt 1958 · S/N 51707N2408CDoughnut Wings Aviation LLC · Lewes, DEBuilt 1955 · S/N 30708N2408FDawson Brent A · Dillingham, AKS/N 18051608N2408GEl Coyote Ranch LLC · Alzada, MTBuilt 1958 · S/N 51708N2408TR E Green Inc · Three Forks, MTBuilt 1962 · S/N NAV-4-2408N2408XWyatt David · Las Vegas, NVBuilt 1965 · S/N 18256308N2409TGarabedian John H · Southborough, MABuilt 1962 · S/N NAV-4-2409N2409XHarrison Nicholas R · Midland, NCBuilt 1965 · S/N 18256309N2409YLow Go Flyers Inc · Jonesville, LABuilt 1955 · S/N 31967
Back to AD 2000-23-21