Registered aircraft · 13,518

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:99-05-13-R1-WD') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:99-05-13-R1-WD') 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:99-05-13-R1-WD')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:99-05-13-R1-WD')
  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:99-05-13-R1-WD')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:99-05-13-R1-WD')
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.

N95WDBurleson Gary L · Myrtle Beach, SCBuilt 1971 · S/N CE-322 N95WHPage William R · Bermuda Dunes, CABuilt 1978 · S/N TK-86 N95WTDs Flight Services LLC · Battle Ground, WABuilt 1966 · S/N TD-677 N95YWhite Tavis · Huntsville, ALBuilt 1964 · S/N TD-604 N9602YMartin James P · Sioux City, IABuilt 1962 · S/N D-7048 N9603YPrimakov Sergey · Melbourne Beach, FLBuilt 1963 · S/N D-7115 N9604KMills Bruce K · Noblesville, INBuilt 1955 · S/N D-4430 N9604RBohl Howard M · Temecula, CABuilt 1959 · S/N BA-464 N9606KPapa Beech LLC · Angola, INBuilt 1962 · S/N D-6947 N9606YWeber David J · Waller, TXBuilt 1962 · S/N TC-368 N960AGLane Jason R · Tuttle, OKBuilt 1967 · S/N D-8538 N960DMMcwilliams Michael D · Conroe, TXS/N D-6543 N960JAce Maker Aviaiton LLC · San Rafael, CABuilt 1961 · S/N TC-170 N9610RReynolds Kirk S · Skaneateles, NYBuilt 1959 · S/N TD-305 N9616YBrady Justin · Bell Buckle, TNBuilt 1962 · S/N DH-337 N9618YBrant Owen D · Delta Junction, AKBuilt 1962 · S/N TC-373 N9619YRutledge Dennis J · Melbourne, FLBuilt 1962 · S/N D-7054 N961SFBdr Aviation LLC · Ponte Vedra Beach, FLBuilt 1964 · S/N D 7541 N961WWMeacham Electric Inc · Marathon, FLBuilt 1970 · S/N CE316 N9620YThoms Robert · Clyde, MIS/N D-7055 N9621RTwin Beech G18s LLC · Galt, CABuilt 1959 · S/N BA-471 N9622RGordon Casey · Los Angeles, CABuilt 1960 · S/N D-6461 N9622YRegistration Pending · Barnwell, SCRegistration pendingBuilt 1963 · S/N D-7173 N96240Southern Aircraft Consultancy Inc Trustee · Casper, WYS/N CA-159 N9625YEwing John L Jr · Yuma, AZBuilt 1962 · S/N D-7059 N9626YLester Jon M · Lancaster, OHBuilt 1963 · S/N D-7172 N9628YDowning Eric D · Saint Charles, MOBuilt 1962 · S/N D-7060 N9629RThomas Christopher A · Seaford, DEBuilt 1959 · S/N TD-307 N9629YSorbi Aviation Inc · El Cajon, CABuilt 1962 · S/N D-7061 N962SBBlack Steven C · Rocklin, CAS/N D-6844 N962SCRegistration Pending · Texas City, TXRegistration pendingBuilt 1960 · S/N TD-359 N962WBeechcraft Heritage Museum Inc · Tullahoma, TNBuilt 1936 · S/N 100 N9630YLuggelle Michael · Hull, MABuilt 1962 · S/N D-7056 N9631RBw Flying Association · Seattle, WABuilt 1959 · S/N TD-314 N9631YTidwell James · Rio Linda, CABuilt 1962 · S/N D-7100 N96335Cysewski Roxanne Trustee · Rllng Hls Est, CABuilt 1983 · S/N EA-400 N9633YFortson Aviation LLC · Brighton, MIBuilt 1963 · S/N D-7150 N9634RMission Flight Academy · Yucaipa, CABuilt 1960 · S/N TC-4 N9636RTrans West Specialties · Visalia, CAS/N TD-317 N9638YKaufman Michael J · Richland Center, WIBuilt 1962 · S/N D-7064 N963QModer Michael T · New Holstein, WIBuilt 1961 · S/N D-6853 N963SGElephant Shoe Air LLC · Vienna, VABuilt 1984 · S/N TJ-452 N9640YCampbell Dennis R · Edmonds, WABuilt 1962 · S/N D-7085 N9642RAvian Flight Center Inc · Bremerton, WABuilt 1959 · S/N TD-328 N9642YGeorge Raymond R · Lake Havasu City, AZBuilt 1962 · S/N D-7062 N9645YBlue Sky Aero LLC · Appleton, WIBuilt 1962 · S/N D-7065 N9646RB-Dog Aviation LLC · Grand Junction, COS/N TD-345 N9647YChampion Aeromotive LLC · Chesterland, OHBuilt 1962 · S/N D-7066 N964DCorporate Consulting Service Instruments Inc · Akron, OHBuilt 1981 · S/N TE-1190 N964HBHubbard Aviators LLC · Harrison, ARBuilt 1964 · S/N D-7629

Back to AD 99-05-13 R1 WD