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.

N1675MWenk Peter J · Ocala, FLBuilt 1971 · S/N 18501867N1675WHarper Jerad Vincent · Windsor, CAS/N CE-398N1675XNo Runways LLC · Iraan, TXBuilt 1975 · S/N 21060710N1676UDigicam Co · Henderson, NVBuilt 1982 · S/N 21064724N1676WTrask Barrett Lee III · Matthews, NCBuilt 1972 · S/N CD-1299N1676XSkydancer Le LLC · Wilmington, DEBuilt 1975 · S/N 21060711N1677CDavis Aero LLC · Incline Village, NVBuilt 1953 · S/N 30377N1677RYarger Denim B · Laurel, MTBuilt 1974 · S/N 185-02400N1677WLagrow II LLC · Coloma, MIBuilt 1973 · S/N CE-419N1678Dgs Aviation LLC · Georgetown, DEBuilt 2026 · S/N 11447N1678RPureflight Aviation Training LLC · Newberg, ORBuilt 1974 · S/N 18502401N1678TGabaldon Martin · El Paso, TXS/N 414-0471N1678XFly Guys LLC · Arcata, CABuilt 1975 · S/N 21060713N1678ZLongmire Dale · Senoia, GABuilt 1962 · S/N 1850470N1679MVaughns Flying Service Inc · Reese, MIBuilt 1971 · S/N 18501870N1679XBouchereau Raymond Jr · San Dimas, CABuilt 1975 · S/N 21060714N1679ZRiemer Emil F · Brush Prairie, WABuilt 1962 · S/N 185-0479N167AJRogers Wallace III · San Antonio, TXBuilt 2017 · S/N 1515N167AWPlane Fun Inc Tr Trustee · Snellville, GABuilt 1978 · S/N 340A0537N167CAGoody For US Aviation LLC · Miami, FLBuilt 2026 · S/N 11191N167CDSouthern Aircraft Consultancy Inc Trustee · Casper, WYS/N 1073N167CTBlomgren Paul · Yorba Linda, CABuilt 2008 · S/N 2959N167JCTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2023 · S/N 9410N167JWStrittmatter Joseph M · Aubrey, TXBuilt 1968 · S/N D-8792N167KMRegistered aircraftBuilt 2025 · S/N 10462N167MStoltzfus Jesse A · Greenfield, OHBuilt 1964 · S/N CD-795N167NGohman Charles Scott · Salinas, CAS/N TE-137N167SPEnnis James D Jr Trustee · Dalton, NHBuilt 2009 · S/N 3580N167TFWhitney David W · Ooltewah, TNBuilt 1967 · S/N D-8472N167TRBarton Aviation LLC · San Antonio, TXBuilt 1998 · S/N TH-1849N167WAGrid Aero Inc · San Leandro, CABuilt 1976 · S/N 402B1044N1680CRogers Terrence W · Almond, WIBuilt 1953 · S/N 30380N1681CClark Eddie · Naknek, AKBuilt 1953 · S/N 30381N1681TDrc Air LLC · Wilmington, DEBuilt 2014 · S/N 4081N1681UMeise Bill · Spring Green, WIBuilt 1982 · S/N 21064725N1682CFly & Fish LLC · Kalispell, MTBuilt 1953 · S/N 30382N1683WAirsouth Aviation Services Inc · Little Rock, ARS/N TC-1526N1683ZSchmitz David K · Spooner, WIBuilt 1962 · S/N 185-0483N1684CBredin William B · Anchorage, AKS/N 30384N1684WHaller Philip L · Peoria, AZS/N D-9386N1685CBallard Heather A · Pleasant Prairie, WIS/N 30385N1686CButts Michael D · Carson City, NVBuilt 1953 · S/N 30386N1686MTerrastar LLC · Kalispell, MTBuilt 1971 · S/N 18501873N1686ZBruegger Shannon B · Lance Creek, WYBuilt 1963 · S/N 1850486N1687WAirway Management Inc · Wilmington, DEBuilt 1972 · S/N E-355N1687XMorton Douglas E · Cody, WYBuilt 1975 · S/N 21060722N16886Maiville Randolph L · Onondaga, MIBuilt 1951 · S/N 22706N1688WDjm Investments Inc · Menno, SDBuilt 1972 · S/N D-9388N1688ZMock David J · Mesa, AZS/N 1850488N1689MR D Offutt Co · Fargo, NDS/N 18264414
Back to AD 2000-23-21