Registered aircraft · 18,497

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

N61PZRoughneck Supply LLC · Muskogee, OKBuilt 1982 · S/N TH-1352 N61RBKiazen Black Mountain Holdings LLC · Black Mountain, NCBuilt 1974 · S/N 21060268 N61RWAerial Services Inc · Cedar Falls, IABuilt 1966 · S/N 320E0001 N61SASierra Alpha Holdings LLC · Albany, NYS/N 0677 N61SMSma Aero LLC · Benton, KSBuilt 1970 · S/N E-199 N61TTGilbert Greg P · Bend, ORBuilt 1988 · S/N CE-1238 N61WWKingsboro David · Menifee, CABuilt 1973 · S/N 340-0203 N6200VProbasco Mitchell L · Floydada, TXBuilt 1967 · S/N D-8482 N6201VUnangst John F · Fort Worth, TXBuilt 1967 · S/N D-8609 N6202BGamache Daniel S · Pleasanton, CABuilt 1978 · S/N 21062706 N6202VHammack Stephen D · Woodbine, GABuilt 1967 · S/N CE-183 N6204VAvcraft Inc · Columbus, NEBuilt 1967 · S/N D-8564 N6207HYr-Aircraft Leasing LLC · Bethel, AKBuilt 1979 · S/N 20700551 N6209C8 Waters LLC · Goodyear, AZBuilt 1979 · S/N 21063830 N6209PFly Fast Live Slow LLC · Chiefland, FLBuilt 1978 · S/N P21000151 N6209XMiller Aviation LLC DBA · Huntington, INBuilt 1978 · S/N 310R1339 N620DFCirrus Consequences LLC · Jacksonville, FLBuilt 2004 · S/N 1117 N620ZSix Twenty Zulu Aviation LLC · Wilmington, DEBuilt 1973 · S/N TH-385 N62119Gavin Michael K · Westport, CTBuilt 1979 · S/N TE-1171 N6211BFleming Patrick J Trustee · Palm Desert, CABuilt 1978 · S/N 21062708 N6212CJensen Consulting Service LLC · Valparaiso, INS/N 0240 N6214VRegistered aircraftBuilt 1968 · S/N U206-1189 N6216VWestphal Robert S Trustee · Mill Valley, CABuilt 1967 · S/N D-8574 N6218VWrather Christopher C · Los Alamos, CABuilt 1967 · S/N D-8651 N6218XFlying Ace Services LLC · Willow Park, TXBuilt 1981 · S/N CE-988 N6218YLucky Star Auto Sales Inc · Grangeville, IDBuilt 1981 · S/N 21064299 N6219CAbbott Todd Christopher · Houston, TXBuilt 1977 · S/N 340A0424 N621AKelsey John · Casa Grande, AZBuilt 1980 · S/N 21064069 N621DEDesert Excavating Inc · Yuma, AZBuilt 2002 · S/N TH-2032 N621GWoolslayer Homer · Tulsa, OKBuilt 1966 · S/N TE-214 N621NMAirmorgan Limited LLC · Reno, NVBuilt 1974 · S/N TH-422 N621RHSchiffer Herbert · West Chester, PABuilt 1991 · S/N E-2654 N621RJWheels Up LLC · Ada, OKBuilt 2002 · S/N 0333 N621SPKokkas Athanasios · Ocala, FLBuilt 1974 · S/N 310R0075 N621WYShowalter Richard L · Beckley, WVBuilt 2005 · S/N 1289 N6221CSahuaro Enterprises Inc · Moreno Valley, CAS/N 340A0426 N6222MBeech Club LLC · La Crosse, INBuilt 1967 · S/N D-8545 N6223BSpirek Aaron M · Henderson, NVBuilt 1978 · S/N 21062712 N6224VAnderson Paul K · Bountiful, UTBuilt 1967 · S/N CE-180 N6225XN6225x LLC · Henderson, TNBuilt 1979 · S/N 340A0688 N6227YWest Brook Group Inc · Pleasant Hill, IABuilt 1981 · S/N 21064301 N6228XMad Doog Aviation LLC · Kalispell, MTBuilt 1977 · S/N 340A0431 N6229CClause James W Trustee · La Quinta, CABuilt 1979 · S/N 21063838 N622DCCarter Aviation LLC · Denver, COBuilt 1977 · S/N 18503465 N622TRL C A Inc · Alamo, CABuilt 1980 · S/N 421C0858 N6231AEtzelmiller Arjay J · Lincoln, NEBuilt 1981 · S/N E-1983 N6232VWallace John B · San Carlos, CABuilt 1968 · S/N E-4 N6233GFlying Cardinals Aircraft Group Inc · Stow, MABuilt 1981 · S/N E-1984 N6233XRdm Ventures LLC · Buckhead, GABuilt 1982 · S/N E-1988 N6233ZMission Aviation Fellowship · Nampa, IDBuilt 1981 · S/N U20606195

Back to AD 86-13-04 R3