Registered aircraft · 18,495

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.

N8168VLandau Stephen C · Whitehouse Station, NJBuilt 2003 · S/N 0790 N8169RPreister Properties LLC · Norfolk, NEBuilt 1974 · S/N D-9668 N816CDDodson International Parts Inc · Rantoul, KSS/N 0150 N816GHSteim Joseph M · Shirley, MABuilt 1978 · S/N 310R1507 N816LATipuani Corp · Dover, DEBuilt 1994 · S/N E-2851 N816LHL Howard Construction Inc · Abernathy, TXS/N 421B0565 N816LMKobylar Lester J · Greensboro, GABuilt 2000 · S/N 29-0250 N816LTSix Lima Tango LLC · Zionsville, INBuilt 2003 · S/N 0511 N816NMidwest Aircraft Inc · Wilmington, DES/N D-8963 N816RJArkansasflyingdoc LLC · Benton, ARBuilt 2001 · S/N 0112 N816UMcmullen Gerald W Trustee · Spokane, WABuilt 1970 · S/N D-9161 N816VBrawler Aviation LLC · Edmond, OKBuilt 1971 · S/N D-9266 N8170AAlpha Aviation LLC · Springfield, MOBuilt 2003 · S/N 0745 N8170EInternational Air Services Inc Trustee · Carson City, NVBuilt 2004 · S/N 0809 N8171GEdge Air LLC · Wilmington, DEBuilt 2003 · S/N 0751 N8171PTravelplus LLC · Knoxville, TNBuilt 2004 · S/N 0797 N8171RYankee Air Pirate LLC · Memphis, TNBuilt 1974 · S/N D-9669 N8171ZRidgeline LLC · Helena, MTBuilt 1993 · S/N E-2785 N8172RDerby City Aviation LLC · Vero Beach, FLBuilt 1974 · S/N TH-515 N8173CJet Pros LLC · Scottsdale, AZBuilt 1990 · S/N CE-1541 N8173MBrazos Air LLC · Mc Gregor, TXBuilt 2003 · S/N 0750 N8173RAdkins Douglas E · Klamath Falls, ORBuilt 1974 · S/N E-593 N8174AHank'S Aviation LLC · Merrillville, INBuilt 2003 · S/N 0721 N8176REpps Elaine · Atlanta, GABuilt 1974 · S/N CJ-53 N8178RW L Landess LLC · Guymon, OKBuilt 1974 · S/N E-594 N8179QCruce Aircraft Services LLC · Clewiston, FLBuilt 1972 · S/N 310Q0635 N817BKChase Aviation Co LLC · Jamestown, NYS/N 1255 N817CAFaze3 Partners LLC · Kalispell, MTS/N E-1724 N817GCMountain View Aeromotive Inc · Del Norte, COBuilt 1975 · S/N 310R0264 N817JPOdom Johnny C · Fredericksburg, TXBuilt 1976 · S/N 414-0850 N817LAUnger William · Missouri City, TXBuilt 1994 · S/N E-2852 N817MJr Mcbride Inc · Carbondale, ILBuilt 2013 · S/N TH-2361 N817MWWright Mark A · Willingboro, NJBuilt 1964 · S/N D-7381 N817NMWest Bound Hound LLC · Sheridan, WYBuilt 1979 · S/N EA-27 N817RMOmega Metals Inc · Douglasville, GABuilt 1981 · S/N EA-203 N8181VPebble Alternative LLC · Harahan, LABuilt 1991 · S/N E-2610 N8182ZWolf Richard Cory · Syracuse, UTBuilt 1963 · S/N 2050182 N8183EGuardado Rodolfo · Sun Valley, CABuilt 1991 · S/N E-2612 N8183MHaman Peter A · Douglas, WYBuilt 1977 · S/N 21062033 N8183RFerriolo Donald J · Greer, SCBuilt 1974 · S/N D-9671 N8184NB & S Holdings LLC · Augusta, GABuilt 1991 · S/N E-2648 N8185RMiles Timothy Neil · Tampa, FLBuilt 1974 · S/N E-595 N8187RFleck Richard N Trustee · Camarillo, CABuilt 1974 · S/N D-9673 N8188QI Will Rise LLC · Chattanooga, TNBuilt 1972 · S/N 310Q0638 N8189RMayer Bari S · Austin, TXBuilt 1974 · S/N CJ-56 N818AKWhirley Robert G · Santa Rosa, CABuilt 1981 · S/N 421C1085 N818ANBank Of Utah Trustee · Salt Lake City, UTBuilt 1981 · S/N 402C0501 N818DBBluebird Holdings LLC · Morris, MNFirst renewal noticeBuilt 1978 · S/N E-1342 N818DLTt1 Marine LLC · Key Largo, FLBuilt 2002 · S/N 0284 N818GMDodson International Parts Inc · Rantoul, KSBuilt 2002 · S/N 0256

Back to AD 86-13-04 R3