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.

N3122MMiller-Jackson Co Inc · Oklahoma City, OKBuilt 1984 · S/N EA-416 N3122UTravel Aviation Inc · Vineyard Haven, MABuilt 1988 · S/N E-2431 N3123WSullivan Dan · Kingwood, TXBuilt 1973 · S/N E-500 N3127WWalkcon Holdings LLC · Amarillo, TXBuilt 1988 · S/N E-2433 N3128WSterling Anthony K · Wilson, NCBuilt 1973 · S/N D-9564 N31291N31291 Aviation LLC · Omro, WIBuilt 1988 · S/N E-2432 N3129UJones Robert M · Brooksville, FLBuilt 1988 · S/N CE-1255 N312CMChristiansen Aviation LLC · Wilmington, DEBuilt 1978 · S/N ME-103 N312LCBenair LLC · Bonita Springs, FLS/N E-3560 N31309Meadowlake Airpark LLC · Lenoir City, TNS/N TC-1524 N3130WWarbirds East Inc · Fairhope, ALBuilt 1973 · S/N TC-1635 N3132LKnutson Wayne R · Thompson, NDFirst renewal noticeS/N MC563 N3132WSteve Rodemer Esq LLC · Colorado Springs, COBuilt 1973 · S/N CE-477 N3135WFlycarolina LLC · Concord, NCBuilt 1973 · S/N D-9538 N3136PCollins Thomas E · Columbus, MSBuilt 1987 · S/N E-2380 N3136XBobbett Robert Todd · West Richland, WABuilt 1998 · S/N EA-620 N3138WN3138w Bonanza V35b LLC · Jeffersonville, INBuilt 1973 · S/N D-9566 N3139LOn Premise LLC · Hannibal, MOBuilt 1987 · S/N CE-1143 N3139WGrace Air LLC · Kalispell, MTBuilt 1973 · S/N E-503 N313DBHelm Walter · Sacramento, CABuilt 1977 · S/N D-10014 N313DKRoark Norman · Greensburg, INS/N D-4553 N313FFerguson John Edward · Santa Ysabel, CABuilt 1958 · S/N D-5764 N313RJNew Hampshire Flying Association Inc · Nashua, NHS/N CE-911 N313WWilliams Thomas James · Clovis, CABuilt 1981 · S/N D-10363 N31444Crossen John R · San Pedro, CABuilt 1988 · S/N CE-1277 N3144HT And C Corp · Wilmington, DEFirst renewal noticeBuilt 1987 · S/N CE-1191 N3144MWhite Ice Holdings LLC · Santa Rosa Beach, FLBuilt 1987 · S/N CE-1206 N3144YSierra Bravo Zulu LLC · Middletown, DES/N E-2437 N3145WIfly Aviation LLC · Conway, ARBuilt 1973 · S/N E-505 N3146WWalker Ernest F · Bala Cynwyd, PABuilt 1973 · S/N CE-479 N3147LBrowning Charles H III · Woodbine, MDBuilt 1994 · S/N E-2882 N3147WTadesco Rothchild LLC · Wilmington, DEBuilt 1973 · S/N D-9569 N31494Locker Aircraft Inc · Muleshoe, TXBuilt 1988 · S/N CE-1269 N31497N400sr LLC · Astoria, NYBuilt 1988 · S/N CE-1275 N314BM & E Financial Markets Research LLC · Fayetteville, NYBuilt 1956 · S/N D-4788 N31526Trostel Manfred E · Longboat Key, FLBuilt 1989 · S/N E-2487 N3152ERegional Medical Consulting Pllc · Mebane, NCBuilt 1994 · S/N E-2880 N3153PWhiskey Mike Aviation LLC · Merrimac, WIBuilt 1994 · S/N E-2884 N3154FMetcalf Management Inc · St George, UTBuilt 1994 · S/N EA-564 N315ABColabianchi Bob J · Fountain Hills, AZBuilt 1975 · S/N D-9740 N315BCasteel Robert C DBA · Elk Grove, CABuilt 1956 · S/N D-4866 N315BPKing Logistics LLC · Ridgeland, MSBuilt 1979 · S/N TC-2230 N315GVancleve Cole · Cotulla, TXBuilt 1965 · S/N TC-907 N315TBartelt Aviation Inc · Sturgis, MIS/N EA-669 N315WDoores Aviation LLC · Copper Canyon, TXS/N E-3515 N3160WPalmetto Wings LLC · Longs, SCBuilt 1973 · S/N E-509 N3161WPritchard Casey M · Bells, TXBuilt 1973 · S/N D-9572 N3163WSkye Peak Corp · Greenfield, MABuilt 1973 · S/N D-9573 N31644Aquarius Aviation Inc · Miami, FLBuilt 1988 · S/N E-2442 N3168PMaxwell Aviation Holdings LLC · Kalispell, MTBuilt 1987 · S/N CE-1104

Back to AD 99-05-13 R1 WD