Registered aircraft · 2,346

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:76-17-03') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:76-17-03') 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:76-17-03')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:76-17-03')
  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:76-17-03')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:76-17-03')
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.

N1000SButler County Warbirds Inc · Middletown, OHBuilt 1972 · S/N AA5-0107 N100XXAskew Stell Blake III · Durham, NCBuilt 1975 · S/N AA1B-0578 N100YAShelton Joel T · Grass Valley, CAS/N AA5-0086 N1012GForwalt Lucas A · Chesapeake, VABuilt 1969 · S/N AA1-0122 N102ASG&P Cheetah LLC · Honolulu, HIBuilt 1977 · S/N AA5A0514 N105NABond Gary G · Harvest, ALBuilt 1978 · S/N AA5B-1016 N1082ZJohnson Henry D · Buena Park, CABuilt 1976 · S/N AA5B0346 N109RWMcpherson Michael A · Stephenville, TXBuilt 1971 · S/N AA1A-0250 N10FAFlanigan Marie C · Lockport, NYBuilt 1972 · S/N AA1A-0337 N10SXAerodynamics Unlimited LLC · Oklahoma City, OKBuilt 1977 · S/N AA5A0303 N1104RInternational Air Services Inc Trustee · Carson City, NVS/N AA5-0471 N1118AKing Charles W · Kelseyville, CABuilt 1976 · S/N AA5A-0192 N111LAAmmons Curtis D · Hernando, MSBuilt 1976 · S/N AA5B-0249 N112FTColesanti Richard A · Poughquag, NYBuilt 1975 · S/N AA5B-0180 N114BJBig Q Aviation · Helena, MTS/N AA5B0656 N1169HSwihart Matthew Allen · San Marcos, TXBuilt 1975 · S/N AA5B-0063 N117LWBlasdel Michael J · Fort Worth, TXBuilt 1975 · S/N AA5B-0057 N117TNNichols Timothy P · Reno, NVBuilt 1976 · S/N AA1B0637 N119EKBrady Michael K · Sammamish, WABuilt 1974 · S/N AA5-0595 N119STSandberg Brian · Lancaster, CABuilt 1975 · S/N AA5B-0119 N11JVHoltz Jeff · Liberty Lake, WABuilt 1977 · S/N AA5B0593 N11LTG T Flying Club LLC · Bellaire, TXBuilt 1977 · S/N AA5B0616 N11ZSSergeant John F C · Fort Myers, FLS/N AA5A-0403 N1234DGonzales Jaime T · Mandeville, LABuilt 1979 · S/N AA5A0860 N123ESPlane Fun Inc Tr Trustee · Snellville, GABuilt 1979 · S/N 1021 N125RMGurtman Samuel · Deerfield, ILBuilt 1978 · S/N AA5B0698 N126DGSouthern Aircraft Consultancy Inc Trustee · Casper, WYS/N AA-5B-0099 N12GANy Flying Tigers LLC · Ronkonkoma, NYBuilt 1977 · S/N AA5B0635 N12PZA5 Flight Club LLC · Saint Cloud, FLBuilt 1974 · S/N AA5-0622 N12VGHashimoto Noriyuki · Rumford, MEBuilt 1971 · S/N AA1A-0187 N130GWBruckner Peter J · Rochester, NHBuilt 1975 · S/N AA50707 N130THDelage Jeffrey R · Biddeford, MEBuilt 1977 · S/N AA5A0398 N131Ekstrand Marshall · Lake Stevens, WABuilt 1972 · S/N AA1B-0050 N1317RVaughan Andy C · Sacramento, CABuilt 1977 · S/N AA5A0323 N1318RWright Wayne S · Linden, MIBuilt 1974 · S/N AA5-0718 N1319RJustusson William · Punta Gorda, FLS/N AA5-0719 N131KYJett Edward C Jr · Bloomfield, KYBuilt 1979 · S/N AA5A0828 N1321RRamineni Raja S · Fort Mill, SCBuilt 1974 · S/N AA5-0721 N1325RDavison Mark L · Vacaville, CABuilt 1976 · S/N AA1B-0615 N1327RYost Alan · North Andover, MABuilt 1974 · S/N AA5-0727 N1328RTrout Fred C · Dallas, GABuilt 1974 · S/N AA5-0728 N1329RDeltondo Ralph P · Fullerton, CAS/N AA5-0729 N1331RGalindo John S · Hurst, TXBuilt 1975 · S/N AA5-0731 N1333RNorris Randy K · Sylvania, GABuilt 1975 · S/N AA5-0733 N1335RHughes Michael · Harvard, MABuilt 1975 · S/N AA5-0735 N1336RManus Phillip P · Tucson, AZS/N AA5-0736 N1337RZimmerman Christopher Paul · Canandaigua, NYBuilt 1975 · S/N AA5-0737 N1339RWilcox Marion L Trustee · La Mesa, CABuilt 1975 · S/N AA5-0739 N1341RTmp Aviation LLC · Altamonte Springs, FLBuilt 1975 · S/N AA5-0741 N1342RGladden Thomas E · Otis Orchards, WABuilt 1975 · S/N AA5-0742

Back to AD 76-17-03