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.

N5175FBroomstick Aviation LLC · Fairfield, IABuilt 2004 · S/N 0818 N5175JAycock Charles C · Midland, TXS/N 340A0010 N5175LAsb Industries LLC · Driggs, IDBuilt 2005 · S/N 1542 N5177MElh Aviation LLC · Flint, MIBuilt 1977 · S/N TJ-116 N5178JSeven Eight Juliet LLC · Edmond, OKS/N 340A0013 N5179UPower Flight LLC · Las Vegas, NVBuilt 1964 · S/N 206-0179 N517CDPeker Lev M · Sylmar, CABuilt 2004 · S/N 1126 N517DJUrquhart Dan DBA · Fallon, NVBuilt 1997 · S/N E-3075 N517KGRegistration Pending · Pittsburg, TXRegistration pendingBuilt 1980 · S/N D10350 N517MHCbtm Aviation LLC · Leesburg, FLBuilt 1976 · S/N 421C0104 N517MPMorey Organization Inc · Wildwood, NJBuilt 2014 · S/N TH-2419 N517PYYoung Millard Perrin · Raleigh, NCBuilt 1970 · S/N CE-305 N517PZPapa Zulu LLC · Bend, ORBuilt 2004 · S/N 0931 N517RBRbc Holdings LLC · San Juan, PRBuilt 2018 · S/N TH-2513 N517SAHalo For Freedom Warrior Foundation · Willow Park, TXBuilt 1966 · S/N U206-0644 N517SWStarship Aviation LLC · Northville, MIBuilt 2003 · S/N 0666 N5180UAssociation Of Baptists For World Evangelism Inc · Harrisburg, PABuilt 1964 · S/N 206-0180 N5181JForce One Inc · Missoula, MTBuilt 1975 · S/N 340A0016 N5182HVanderpool Robert W · Red Devil, AKS/N 18503326 N5182JEmery & Associates Inc · Orangeville, PAFirst renewal noticeS/N 340A0017 N5183WG S I Training Services Inc · Branson, MOBuilt 1981 · S/N P21000650 N5186UHumphrey Jeffrey · Corvallis, MTBuilt 1964 · S/N 206-0186 N5188USky Stallion LLC · Winter Park, FLBuilt 1964 · S/N 206-0188 N5189ABarrymore Cole · Government Camp, ORBuilt 1979 · S/N 21063302 N5189YKmc Aviators LLC · Burlington, CTBuilt 1980 · S/N 21064114 N518ABVickery Hawk Partners LLC · Fort Worth, TXBuilt 1974 · S/N CE-518 N518BBas Part Sales LLC · Greeley, COBuilt 1973 · S/N 421B0518 N518CDCornerstone Auto Parts LLC · Pratt, KSBuilt 2004 · S/N 1229 N518HJArmstrong Consolidated LLC · Anchorage, AKBuilt 1971 · S/N 18501930 N518LSeehimfly LLC · Spring, TXBuilt 2003 · S/N 42028 N518MMull Jason E · Chester, NYBuilt 1970 · S/N D-9111 N518MDGreens Aviation LLC · Lebanon, OHBuilt 2004 · S/N 1183 N518PCJnc Holdings LLC · Mequon, WIBuilt 1977 · S/N 340A0433 N5191URobles Marcos F · Oracle, AZBuilt 1964 · S/N 206-0191 N5191VTrue Drilling LLC · Casper, WYBuilt 1975 · S/N 21060857 N5193UCox Paul G DBA · Bryce, UTBuilt 1964 · S/N 2060193 N5195AOlson Brothers · Williams, AZBuilt 1979 · S/N 21063304 N5198UFerguson Kenneth R · Tehachapi, CABuilt 1964 · S/N 206-0198 N5198VMaddock Jay B · Sugar Grove, ILS/N 21060859 N519CMCygnet Aerospace Corp · Los Osos, CAS/N TJ-56 N519DHDavis Steven Jeffry Trustee · Poway, CABuilt 2002 · S/N 0233 N519EAFff LLC · West Lafayette, INBuilt 2017 · S/N 0001 N519MQMgnh Services LLC · Houlton, MEBuilt 1983 · S/N 18504413 N519RRothacker Aviation LLC · Wilmington, DEBuilt 1986 · S/N CE-1083 N519SCCrockett Ryan · Veradale, WAFirst renewal noticeBuilt 1979 · S/N 340A0720 N51APConrad Alan B · Las Vegas, NVBuilt 1980 · S/N 340A0970 N51BWMcclymond Bruce W · Breckenridge, TXBuilt 1981 · S/N 21064602 N51CMCorley W Michael · Mc Minnville, TNBuilt 1972 · S/N 21059628 N51CXAerodata LLC · Ann Arbor, MIBuilt 1978 · S/N 340A0533 N51ECVesely & Co Inc · Houston, TXBuilt 1995 · S/N E-2983

Back to AD 86-13-04 R3