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

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.

N343RBAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1973 · S/N TC-1553 N343RCHoekstra David A · Roswell, NMBuilt 2007 · S/N 41768 N343STJagc LLC · Freeport, FLBuilt 2015 · S/N 4264 N343TXZbeb Express LLC · Kalispell, MTBuilt 2011 · S/N 0112 N343UElliott Russell L · Salem, ORBuilt 1967 · S/N CE-145 N343ZMBuzzard Aviation LLC · St Simons Island, GABuilt 1955 · S/N G-303 N3440SLynch Chris A · Sedro Woolley, WABuilt 1964 · S/N 18255840 N3440UPlane Joy LLC · Payson, AZBuilt 1963 · S/N 18254840 N3441FLawrence Kam M · Big Bear City, CABuilt 1966 · S/N 18257441 N3441RQualtieri John E · Fallon, NVS/N 18258741 N3441SSun Technology LLC · Cheyenne, WYBuilt 1964 · S/N 18255841 N3441UDemeyer Scott M · Olympia, WABuilt 1963 · S/N 18254841 N3441YBird Avery L · Wasilla, AKBuilt 1968 · S/N 18051941 N3442SRail Birds · Clearfield, UTBuilt 1964 · S/N 18255842 N3442TBoyle Ventures LLC · Rogers, ARBuilt 2010 · S/N 3710 N3443Registered aircraftBuilt 1978 · S/N CE-761 N3443RBertrand John E · Trion, GABuilt 1967 · S/N 18258743 N3443SWilliams Forest Chem LLC · Columbus, GABuilt 1964 · S/N 18255843 N3443UHall George K · Cathedral City, CABuilt 1963 · S/N 18254843 N3443YTurner Nathan D · Nenana, AKBuilt 1968 · S/N 18051943 N3444FAtwood David E Trustee · Nampa, IDBuilt 1966 · S/N 18257444 N3444LDierick Greg E · Yakutat, AKS/N U206-0744 N3444QKeystone Aerial Surveys Inc · Philadelphia, PABuilt 1966 · S/N 320E0044 N3444SBraha Thomas I · Mansfield, PABuilt 1964 · S/N 18255844 N3444ULepton Films LLC · Tarzana, CABuilt 1963 · S/N 18254844 N3445FAltus Aircraft LLC · Taylor, TXBuilt 1966 · S/N 18257445 N3445LYama Air LLC · Granite Bay, CABuilt 1966 · S/N U206-0745 N3445SBigfoot Aviation LLC · Shelton, WAS/N 18255845 N3446UTempus Morgan C · Cameron Park, CABuilt 1963 · S/N 18254846 N3447FEngh David Trustee · Wickenburg, AZBuilt 1966 · S/N 18257447 N3447LHulst Damon M · Santa Barbara, CABuilt 1966 · S/N U206-0747 N3447S182 Corp · Rockford, ILBuilt 1964 · S/N 18255847 N3448FLarson Peter · Sheyenne, NDBuilt 1966 · S/N 18257448 N3448RFour Eight Romeo LLC · Shallowater, TXBuilt 1967 · S/N 18258748 N3448UHigh Planes Flyers Inc · Fort Collins, COBuilt 1963 · S/N 18254848 N3449FKunkel John A · Pine River, MNS/N 18257449 N3449RRobinson Timothy A · Casa Grande, AZBuilt 1967 · S/N 18258749 N3449UHicks Brian Joseph · Shingle Springs, CABuilt 1963 · S/N 18254849 N3449YSteel Rock Aviation LLC · West Jordan, UTBuilt 1968 · S/N 18051949 N344ARpm Aviation LLC · San Antonio, TXBuilt 2007 · S/N 2888 N344ACInternational Air Services Inc Trustee · Carson City, NVBuilt 1978 · S/N 28R-7803350 N344AHAdams Flying Service Inc · Rayville, LABuilt 1978 · S/N 310R1371 N344AJQualitair LLC Trustee · MichelstadtBuilt 1980 · S/N 21063891 N344BCote Stephen P · Montgomery, TXS/N D-4953 N344CDAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2002 · S/N 0156 N344GJMeyer William R · Oak Grove, MOBuilt 2021 · S/N 2394 N344JPCentral Virginia Aviation Inc · North Dinwiddie, VAS/N 35713 N344JSWhitewing Aviation LLC · Tuscola, TXBuilt 1979 · S/N 340A0781 N344KLeblanc Debrah · Zachary, LABuilt 1975 · S/N 18263709 N344KVLutz Gregory J · East Bridgewater, MABuilt 1960 · S/N 57470

Back to AD 2000-23-21