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.

N1813BRr Aviation Services LLC · Wichita, KSBuilt 1981 · S/N E-1879 N1813YWarren Clifton W · Camarillo, CABuilt 1981 · S/N CE-961 N18142Aviation Trust Co LLC · Oklahoma City, OKBuilt 1981 · S/N TH-1270 N1814CSun Desert Enterprises · Spicewood, TXBuilt 1981 · S/N TC-2365 N1814EErda LLC · Wilmington, DEBuilt 1981 · S/N EA-241 N1814FAlpine Cable And Construction Inc · Grand Junction, COBuilt 1965 · S/N 21058714 N1814SUnited Mobile Auctions Aviation LLC · Mooresville, NCBuilt 1981 · S/N E-1883 N1815DOdell Ryan S · Yukon, OKS/N D-10376 N1815FIss Holdings LLC · Lady Lake, FLBuilt 1981 · S/N E-1886 N1815GGalaxy Aviation LLC · Nantucket, MABuilt 1981 · S/N D-10379 N1815HPlane Fun Inc Tr Trustee · Snellville, GABuilt 1976 · S/N 21061148 N1815LEagles Rise Aviation LLC · Wales, MAS/N TJ-63 N1815MReim Rodney D · Enid, OKBuilt 1971 · S/N 33701415 N1815ROsprey Island Lodge Inc · Eagle River, AKBuilt 1974 · S/N 18502530 N1816FMalcom Scott O · Toledo, WABuilt 1965 · S/N 21058716 N1816HKiever Robert P · Summerland Key, FLBuilt 1959 · S/N 35916 N1816JWakefield Aircraft LLC · Cooperstown, NDS/N 182-68574 N1816RArizona Game & Fish Dept · Phoenix, AZBuilt 1974 · S/N 18502531 N1817AKlinefelter Kristopher J · Phoenix, AZBuilt 1981 · S/N EA-243 N1817LLorenzo Timothy A · Eureka, CABuilt 1976 · S/N E-839 N1817SClear Skies LLC · Stuart, FLBuilt 1981 · S/N TH-1271 N1817XSale Reported · Roseville, MNSale reported, pending cancellationBuilt 1965 · S/N 18255917 N1817ZOrr Lynn E · Fredericksburg, OHBuilt 1981 · S/N TJ-386 N18182Samaha Fadi · Point Roberts, WABuilt 1975 · S/N 18263913 N1818AMaas Nancy C · Redding, CABuilt 1978 · S/N 18266532 N1818XBeech Jet 324 LLC · Delray Beach, FLBuilt 2000 · S/N E-3302 N1818YLemonides Charles S · Bridgehampton, NYBuilt 1981 · S/N E-1888 N18190Miller Chad A · Many, LAS/N TC-2403 N1819LBlack Kettle Inn LLC · Cabool, MOS/N E-838 N1819MDjb Asset Management LLC · Oakdale, CABuilt 1981 · S/N EA-245 N1819XGrant Steven T · Sellers, SCBuilt 1964 · S/N 18255919 N181ACTwo Tall Tamaracks LLC · Ovando, MTBuilt 1980 · S/N CE-914 N181AMMolny Adam J · Naples, FLBuilt 2012 · S/N L2K-151 N181ATNazario Rafael · Delray Beach, FLBuilt 1973 · S/N 18262686 N181BCBlue Chip Aviation Services LLC · Cincinnati, OHBuilt 2026 · S/N 11143 N181CBBuchanan Clayton W · Fernandina Beach, FLBuilt 1970 · S/N D-9124 N181CCLegacy Air Services LLC · Lafayette, LABuilt 2019 · S/N 2017 N181CDG3 Estates LLC Trustee · Lakeland, FLBuilt 2000 · S/N 1083 N181CPEighty1 Aviation LLC · Canton, GABuilt 1964 · S/N 18255766 N181DBPleasant City Aviation LLC · Shelby, NCBuilt 2020 · S/N 2212 N181DHWinkler Jeffery L · Brush, COBuilt 1964 · S/N 206-0220 N181EWoodhead Matthew E Trustee · Reno, NVBuilt 1979 · S/N 18267304 N181FMLuse Otis · Lago Vista, TXS/N 34-7770400 N181JBBarrows Grayson J · Mcminnville, ORBuilt 1963 · S/N 18051329 N181JMMccloy John S · Lakeland, FLBuilt 1953 · S/N 30145 N181JPRegistered aircraftS/N CE-965 N181JRCavu Clearing LLC · Palm Coast, FLBuilt 1982 · S/N TJ-363 N181JWSkyhaven Aviation LLC · Steamboat Springs, COBuilt 2009 · S/N 3591 N181KTRegistered aircraftBuilt 2000 · S/N 30-0056 N181LDL&M Columbia 181 LLC · Chandler, AZBuilt 2007 · S/N 41643

Back to AD 2000-23-21