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.

N437MHolland Michael A · Tomah, WIBuilt 1947 · S/N NAV-4-703FN437PAEsa Montana LLC · Helena, MTBuilt 2007 · S/N 31-0047N437RPPastusek Robert R · Granbury, TXBuilt 2008 · S/N LIV-437N4380DLivengood Leasing Co LLC · Mesa, AZBuilt 1985 · S/N 46-8508045N4380S9791m LLC · Tacoma, WABuilt 1984 · S/N 46-8508020N4380WAtaraxia Aircraft Holdings LLC · Greenville, SCBuilt 1974 · S/N TH-448N43848White David W · New River, AZS/N 28R-7703317N4384KLewis Flying Service Inc · Morse, LABuilt 1967 · S/N 18051827N4384TTaw Development Inc · Raleigh, NCBuilt 1984 · S/N 46-8508028N4384WPacific Media Properties Inc · Santa Ana, CABuilt 1974 · S/N E-536N4386NFreedom Airplane Jv 1 LLC · Pensacola, FLBuilt 1985 · S/N 46-8508039N4387DTravel Direct LLC · Montevideo, MNBuilt 1985 · S/N 46-8508040N4387FValiair Lc Trustee · Casper, WYBuilt 1978 · S/N 34-7670336N4388MMalibu 88mike LLC · Duncanville, TXBuilt 1985 · S/N 46-8508047N4388WNiezen Henry J · San Luis Obispo, CABuilt 1974 · S/N D-9600N438APWhiskey 340 LLC · Tucson, AZBuilt 1977 · S/N 340A0438N438CDSquibb Daniel · Xenia, OHBuilt 2005 · S/N 1404N438GMRye Air LLC · Grimes, IABuilt 2000 · S/N E-3353N438PCJaml Aviation LLC · Happy Valley, ORBuilt 2010 · S/N 3625N438SR10sm Clr LLC · Oklahoma City, OKBuilt 2007 · S/N 2567N438TBluhm Raymond M · Waxhaw, NCBuilt 1971 · S/N D-9256N438YHogge Dennis · Canby, ORBuilt 2000 · S/N LIV-298N43911Scud Runner LLC · Cape Coral, FLBuilt 1985 · S/N 46-8508059N4391EN4391e LLC · Scottsdale, AZBuilt 1985 · S/N 46-8508054N4393AOgilvie Terry Michael · Loveland, COBuilt 1970 · S/N CE-300N4394WSisson James M · Orlando, FLBuilt 1974 · S/N TH-460N43970Arrow N43970 LLC · Derry, NHBuilt 1977 · S/N 28R-7703321N43994Harrison Shawn · Salisbury, MDBuilt 1977 · S/N 28R-7703327N439NKSt Louis Aircraft Partners LLC · Saint Louis, MOBuilt 2004 · S/N 0919N439SFCarter Randy C · Poway, CABuilt 1995 · S/N 29-0039N439TSale Reported · Ochlocknee, GASale reported, pending cancellationBuilt 1961 · S/N CD-317N43ABV Tail Flyers Llp · South Lyon, MIBuilt 1959 · S/N D-5838N43AKEarth Center Adventures Inc · Haines, AKBuilt 1980 · S/N U20605545N43ATOld Virginia Properties LLC · Cedar Bluff, VABuilt 1965 · S/N TC-881N43BBHilyer Bruce W · Camano Island, WABuilt 1990 · S/N CE-1517N43CPMountain View Industries LLC · Missoula, MTBuilt 1979 · S/N P21000398N43DAAero Management Holdings LLC · Hot Springs, ARBuilt 1976 · S/N 340A0112N43DBMuller Michael C · Peachtree City, GABuilt 1968 · S/N TE-617N43DEReynolds Carl R · Bryn Mawr, PABuilt 1977 · S/N 18266212N43DW10-4 Aviation LLC · Waco, TXBuilt 1974 · S/N 310R0135N43FMBaseline Digital Inc · Satellite Beach, FLBuilt 1998 · S/N 29-0139N43GRN43gr LLC · Phoenix, AZS/N 1531N43GWAero Development LLC · Mesa, AZBuilt 2023 · S/N L2K-322N43HLKimbrell Heath G · Quinlan, TXBuilt 1957 · S/N 34652N43HPBarbara Aviation Inc · Middletown, DEBuilt 1977 · S/N TH-885N43HWPiper Nicholas W · Nanjemoy, MDBuilt 2000 · S/N 29-0259N43JKEvans James · Millbrae, CABuilt 1973 · S/N 18262576N43KBNeves John Herbert Jr · Livermore, CAS/N 2N43KMSns Real Estate LLC · Portland, ORBuilt 2026 · S/N 11375N43KNSkyforge Holdings LLC · Asheville, NCBuilt 2026 · S/N 11438
Back to AD 2000-23-21