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.

N2904QBoley Richard J · Hayward, WIBuilt 1978 · S/N 18503541 N29059Ens Aviation LLC · Marshall, TXBuilt 1968 · S/N U206-1043 N2905TZephyr Enterprises Inc · Wilmington, DEBuilt 1966 · S/N 306 N29061Swalling Frederick M · Anchorage, AKBuilt 1968 · S/N U206-1045 N29068Jd Flying LLC · Bellingham, WABuilt 1968 · S/N U206-1049 N29084D E C Holdings · Hansen, IDBuilt 1972 · S/N 21059798 N2908TRegistered aircraftBuilt 1966 · S/N 309 N2909TSmith David W · Milaca, MNS/N 314 N290CAHyannis Air Service Inc · Hyannis, MABuilt 1980 · S/N 402C0297 N290SGinter Aviation LLC · Oakland, MDBuilt 1971 · S/N E-292 N29110Sutton Aircraft Salvage LLC · Palmer, AKBuilt 1968 · S/N U206-1080 N29113Figueroa Angel Lara · Winfield, ALBuilt 1973 · S/N 21059806 N29114Grey Goose LLC · Wasilla, AKBuilt 1968 · S/N U206-1084 N29127Shivers William L Jr · Friday Harbor, WABuilt 1968 · S/N U206-1097 N2912TKrahling Jeffrey B · Redding, CABuilt 1966 · S/N 318 N29130Ernst Gregory R · Eagle Creek, ORS/N U206-1100 N29138Allen Brent H · Mammoth Lakes, CABuilt 1973 · S/N 21059815 N2913TBlaine Christopher · Friday Harbor, WABuilt 1966 · S/N 319 N29142Hall Darryl Wayne II · Wasilla, AKS/N U206-1112 N2914YBol Aero LLC · Beverly Hills, CABuilt 2004 · S/N 0859 N29151Inland Aerial Surveys Inc · Riverside, CABuilt 1968 · S/N U206-1121 N2915BRobble Group LLC · Center Valley, PABuilt 1986 · S/N E-2314 N29164Iturriria John · Kuna, IDBuilt 1968 · S/N U206-1133 N2916TLewis Paul A · Spring, TXBuilt 1966 · S/N 322 N29173Aerial Transport LLC · Wilmington, DEBuilt 1968 · S/N U206-1140 N29176Tgr Helicopters · Fresno, CABuilt 1973 · S/N 21059828 N29181Wings Of Faith · Stevensville, MTBuilt 1968 · S/N U206-1147 N29186Thoroughbred LLC · Kalispell, MTBuilt 1968 · S/N U206-1151 N29188Rugger Investment Group LLC · Tustin, CABuilt 1968 · S/N U206-1153 N29190Mountain Helicopters LLC · Salt Lake City, UTBuilt 1973 · S/N 21059830 N2919TParsons William Tony Jr · Medina, TNBuilt 1966 · S/N 325 N291ABSerafini Louis · Ringwood, NJBuilt 1970 · S/N D-9119 N291CMAutorific High Performance Carwash Inc · Roxboro, NCBuilt 2007 · S/N TH-2195 N291RBAbbott Air Inc · Hydro, OKBuilt 1982 · S/N 414A0836 N29204Jms Aviation LLC · Waynesville, OHS/N U206-1162 N29209Bas Part Sales LLC · Greeley, COBuilt 1973 · S/N 21059832 N2920GStevenson Taylor A · Dallas, TXBuilt 1980 · S/N 340A0115 N29210Hawkes Brian R · Hamilton, MTBuilt 1968 · S/N U206-1165 N29217Dawson Adam J · Eveleth, MNBuilt 1968 · S/N U206-1171 N2921BMurray Michael E · Fallbrook, CABuilt 1964 · S/N D-7372 N29224Phelan Ricky Ray · Jefferson, ORBuilt 1968 · S/N U206-1176 N29278Pancho Moreno Y La Flaca LLC · Camuy, PRBuilt 1973 · S/N 21059852 N29289Disarro Wayne · Wasilla, AKBuilt 1968 · S/N U206-1211 N29292Skytime Aviation LLC · Tulsa, OKBuilt 1968 · S/N U206-1212 N29299Svetic Russell T · Redondo Beach, CABuilt 1968 · S/N U206-1216 N292CDContrails Aviation LLC · Minneapolis, MNBuilt 2004 · S/N 1130 N292MWGroth Greg · Cookeville, TNBuilt 1994 · S/N E-2862 N292RSValiair Limited Company Trustee · Casper, WYBuilt 1980 · S/N 414A0482 N29359Cervantes Jose DBA · San Diego, CABuilt 1973 · S/N 21059858 N2939ARwrb LLC · Conway, ARBuilt 1969 · S/N CE-286

Back to AD 86-13-04 R3