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

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

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.

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

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

N25LHCole Aviation LLC · Wichita, KSBuilt 1985 · S/N 46-8508070 N25LQKpj Aviation LLC · West Palm Beach, FLBuilt 2026 · S/N 11305 N25LRRoam Airlines LLC · Eugene, ORBuilt 1981 · S/N EA-196 N25LSBzaviation LLC · Saint Louis, MOBuilt 1994 · S/N E-2838 N25LTCaudell Currin B · Dallas, TXBuilt 1957 · S/N D-5330 N25MLAzalea Grove LLC · Ruston, LABuilt 2005 · S/N 1571 N25MMFairweather Aviation Leasing LLC · Haines, AKFirst renewal noticeBuilt 1975 · S/N 18502827 N25MVTeam Jet LLC · Howell, MIBuilt 2001 · S/N 0095 N25NHGrey Sky LLC · Bossier City, LABuilt 2008 · S/N 411071 N25PCTacoma Arrow Plane LLC · Tacoma, WABuilt 2016 · S/N T24002122 N25PDKnew Man Group LLC · New Orleans, LABuilt 1994 · S/N 3448050 N25QGrant Janice · Friday Harbor, WABuilt 2001 · S/N E-3398 N25QYCuller Richard E · Winston Salem, NCBuilt 1976 · S/N CE-653 N25RDHamilton Robert L · Vashon, WABuilt 1971 · S/N CE-358 N25RFMlf Aviation LLC · Douglasville, GABuilt 1973 · S/N 340-0307 N25RHPoseidon Transport Inc · Watertown, NYBuilt 1982 · S/N CE-1009 N25RXOlde Same Place LLC · Thiensville, WIBuilt 1971 · S/N TE-832 N25SCBlain Robert John · Billings, MTBuilt 1966 · S/N 185 1055 N25SFStorage Units Capital Aviation LLC · Maitland, FLBuilt 2023 · S/N 9635 N25TAJms Properties Inc · Hudsonville, MIBuilt 1982 · S/N 340A1538 N25TEBostyancic Derek J · Grand Rapids, MNBuilt 2025 · S/N 10707 N25TMYankee Tango Mike LLC · Dublin, TXS/N EA-265 N25UPNewsome Jeffery S · Blackwell, OKBuilt 1977 · S/N E-987 N25VBOtto Aircraft Sales Inc · Sarasota, FLBuilt 1976 · S/N D-9841 N25VLV-Jet Sr 22 Partnership LLC · Santa Monica, CABuilt 2022 · S/N 8654 N25WDSale Reported · Greeley, COSale reported, canceledBuilt 1978 · S/N P21000094 N25WLSchein William · Santa Fe, NMBuilt 1992 · S/N 25 N25WWRainey Aerial Ag Service Inc · Obion, TNBuilt 1976 · S/N E-842 N25YTCtd Management LLC · Anderson, SCFirst renewal noticeBuilt 2017 · S/N 4456 N25ZZ25zz LLC · Abilene, TXS/N 18267202 N2600Klasson Human Capital Partners LLC · Centerville, OHBuilt 2005 · S/N 1552 N2600FZorrilla Peter · Charles Town, WVS/N 18256700 N2600GBad Company Aviation LLC · Peachtree Corners, GABuilt 1959 · S/N 51900 N2600QBivens Jason D · Duncan, OKBuilt 1966 · S/N 18257800 N2600ROrlandella Vito P · Auberry, CABuilt 1967 · S/N 18258300 N2600YCurrin Thomas E · Pendleton, ORBuilt 1962 · S/N 18051100 N2601FFly3h4 LLC · Hillsboro, NDBuilt 1965 · S/N 18256701 N2601RHarden Aviation LLC · Washington, PABuilt 1969 · S/N 28R-35223 N2602CRrb Aviation LLC · Jasper, TXBuilt 1954 · S/N 35002 N2602GConran Joshua · Belmont, MIBuilt 1959 · S/N 51902 N2602RSiegel Jeffrey P · Snowmass Village, COS/N 18258302 N26030Lessing Aviation LLC · Denver, COBuilt 1985 · S/N 46-8508107 N2603FHolloway Graham · Orcutt, CABuilt 1965 · S/N 18256703 N2603KPadilla Management Inc · Burlington, WABuilt 1978 · S/N 18053013 N2603RHopper Jeremy G · Amity, ORS/N 18258303 N2604GBlessing Christopher B · Houston, DEBuilt 1959 · S/N 51904 N2604SGillespie Dan L · Discovery Bay, CABuilt 1968 · S/N 337-0904 N2604YLawson Charles A · Arlington, WABuilt 1962 · S/N 18051104 N2605FRose Walter W · Arena, WIBuilt 1965 · S/N 18256705 N2605GInnes Stephen L · Bentonville, ARBuilt 1959 · S/N 51905

Back to AD 2000-23-21