Skip to content

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.

N3765YBott David F · Yukon, OKBuilt 1963 · S/N 21058265 N3766YPyanov Mark · Clinton, MSS/N 21058266 N37676Campbell & Associates Investment Properties LLC · Burleson, TXBuilt 1974 · S/N 421B0584 N376CDWestern Chancellor LLC · Fort Worth, TXBuilt 2005 · S/N 1425 N376CWWeavers Enterprises LLC · Annville, PABuilt 1976 · S/N 76-30841 N376RHSeckel Dean · Mount Vernon, WABuilt 1998 · S/N EA-612 N3770QTaylor Zachary S · Shawnee, OKBuilt 1967 · S/N D-8403 N3770YBig Bend C C Foundation · Moses Lake, WABuilt 1963 · S/N 21058270 N3772QBoav8r LLC · Marana, AZBuilt 1967 · S/N D-8405 N3772YKossuth Keith E · Sleepy Hollow, CAS/N 21058272 N3774YLanning 2 Aviation LLC · Amarillo, TXBuilt 1963 · S/N 21058274 N3777SStuart Guy · Owosso, MIBuilt 2000 · S/N E-3351 N3778YTime Air LLC · Mendon, UTBuilt 1965 · S/N T210-0034 N3779YJoiner Matthew A · Temple, GABuilt 1963 · S/N 21058279 N377AMJohnstone Inc · Wilsonville, ORS/N E-63 N377CDAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2004 · S/N 1022 N377CEMetal Mistress Aviation LLC · Meadowview, VABuilt 1976 · S/N 310R0631 N377CFCohen Rolando S · New York, NYBuilt 1974 · S/N 20700275 N377DShawn Wyatt Enterprises Inc · Huntsville, TXBuilt 1983 · S/N E-2087 N377JS270 Aviation LLC · Elizabethtown, KYBuilt 1979 · S/N 340A0672 N377KCEagle Flying Club LLC · Enid, OKBuilt 1977 · S/N E-1032 N377RFGlobal Flight Support And Sales Inc · Tampa, FLBuilt 1987 · S/N CJ179 N377WBradley Aviation LLC · Whiteland, INS/N TE-683 N377WMQualitair LLC Trustee · MichelstadtBuilt 1970 · S/N 18260411 N3781QWelch Michael R · Roanoke, TXBuilt 1967 · S/N D-8417 N3783YThompson Arthur H Jr · Hereford, AZBuilt 1963 · S/N 21058283 N3784YQualitair LLC · MichelstadtS/N 21058284 N3785QGo Fly Missoula LLC · Missoula, MTBuilt 1967 · S/N D-8413 N3785YNational Snake Team LLC · Benton, LABuilt 1964 · S/N 21058285 N3786YWilliams John D · Geneva, OHBuilt 1963 · S/N 21058286 N3788QSale Reported · Oklahoma City, OKSale reported, canceledBuilt 1967 · S/N D-8410 N3789QHercules Jesse T · Memphis, TNS/N D8412 N378FJSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2003 · S/N 40076 N378GPE Graham Investments LLC · Sanford, FLBuilt 1975 · S/N CE-602 N378JRay Preston C · Chula Vista, CABuilt 1967 · S/N D-8421 N378SStarr William E · Eagle River, AKBuilt 1979 · S/N U20604967 N378SPCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1981 · S/N U20606322 N3791YSatanta Flying Service Inc · Satanta, KSBuilt 1964 · S/N 21058291 N3793QMartin Tully T · Idalou, TXBuilt 1967 · S/N D-8418 N3793YBest Aircraft Deals LLC · Salt Lake City, UTBuilt 1964 · S/N 21058293 N3795QGreen Aviation Inc · Manchester, MEBuilt 1967 · S/N TE-328 N3796CPro Aire Cargo & Consulting Inc · Oshkosh, WIBuilt 1974 · S/N 402B0803 N3796GSantos Aviation LLC · Chico, CABuilt 1977 · S/N 310R0914 N3797QKolb Norman R · Tijeras, NMBuilt 1967 · S/N D-8415 N3797YCockroft Roger · Baltimore, MDBuilt 1964 · S/N 21058297 N3798QMartin-Fosters Fuel Service Inc · Seminole, OKBuilt 1967 · S/N D-8416 N3799MWaldron Ronald · Strongsville, OHBuilt 1980 · S/N E-1774 N3799PCt Services LLC · Albuquerque, NMBuilt 1978 · S/N P21000055 N3799QDtb Aviation Inc · Los Gatos, CABuilt 1967 · S/N D-8433 N379CDOptimal Aircraft Management Mi LLC · Sanford, MIBuilt 2005 · S/N 1465

Back to AD 86-13-04 R3