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.

N457BBRlm Investment Holdings LLC · Wilmington, NCBuilt 1994 · S/N TH-1712 N457DFUsda Forest Service Fepp · Mcclellan, CABuilt 1982 · S/N TH-1354 N457DKMiller Gordon J Jr · Monaca, PABuilt 2003 · S/N 29-0313 N457DMMajor Development LLC · Cedaredge, COBuilt 1978 · S/N 340A0554 N457DTMathew Reggie T · Satellite Beach, FLBuilt 1997 · S/N E-3095 N457JNToerner Investments · Findlay, OHBuilt 1975 · S/N D-9807 N457MSNesk Aviation LLC · Orlando, FLBuilt 1979 · S/N E-1523 N4580KHarrah Daniel R · Juneau, AKBuilt 1979 · S/N P21000223 N4581SDaum Jeffrey A · Ocala, FLBuilt 1975 · S/N D-9808 N4584SAd Astra Aviation LLC · Shawnee, KSBuilt 1975 · S/N E-751 N4585MCorman Bruce D · Burlington, COBuilt 1978 · S/N E-1239 N4585SValiair Limited Company Trustee · Casper, WYBuilt 1975 · S/N E-752 N4586SEjh Teton Properties LLC · Petaluma, CABuilt 1975 · S/N D-9809 N4587SSims Chad L · Marshall, TXBuilt 1975 · S/N E-753 N4588APlane LLC · Shady Shores, TXBuilt 1970 · S/N TE-810 N4589NGeneric Implant Solutions LLC · Pratt, KSBuilt 1978 · S/N 340A0556 N458CAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2002 · S/N 0388 N458CTAratow Michael · Mountain View, CABuilt 2000 · S/N EA-661 N458DGIron Street Aviation LLC · North Kansas City, MOBuilt 1973 · S/N TH-296 N458DJSurvey America Inc · Rancho Cordova, CABuilt 1980 · S/N U20605833 N458JHVliegtuig Holdings LLC · Kalispell, MTBuilt 1996 · S/N E-3037 N458KAugust Aero LLC · Kalispell, MTBuilt 1974 · S/N TH-452 N458RHHamil Robert D · Houston, TXBuilt 2005 · S/N 1688 N458SSSos Ranch LLC · Humble, TXBuilt 1975 · S/N TH-569 N458TWFirst Aviation Co · Prospect Heights, ILBuilt 2003 · S/N 0697 N458VCWing And A Prayer LLC · Sarasota, FLBuilt 1974 · S/N 421B0915 N4590SConner Chad E · Paris, TNBuilt 1975 · S/N TH-676 N4591KDesmon David L · Everett, WABuilt 1948 · S/N NAV-4-1591 N4592SMays Robert · Centerville, TNBuilt 1976 · S/N TJ-87 N4594CSt Johns Aviation LLC · Saint Johns, MIBuilt 1979 · S/N 21063569 N4594ELingo Joshua B · Lake Village, ARBuilt 1979 · S/N 18503805 N4595SHurst Sheldon G IV · Smyrna, GABuilt 1975 · S/N D-9812 N4596FJaysix LLC · Greeley, COBuilt 1966 · S/N 185-1150 N4596SWaters Mark N · Clovis, NMS/N CE-685 N4596URustair Inc · Anchorage, AKBuilt 1979 · S/N U20604990 N4597FWarden Richard L · Canby, ORBuilt 1966 · S/N 185-1151 N4597STopflight Air LLC · Dunkirk, INBuilt 1975 · S/N E-757 N4598MRegistered aircraftS/N D-10121 N4599FCcs Flight Services LLC · Benton Harbor, MIS/N 340A0652 N459CCLemon James M · Billings, MTBuilt 1971 · S/N 18501916 N459CDUrsine Teleportation LLC · Redmond, WABuilt 2005 · S/N 1535 N459DMStafford Wings LLC · Fredericksburg, VABuilt 1981 · S/N 421C1084 N459JDWilson John K · Rosamond, CABuilt 1970 · S/N E-210 N459RWUmatilla Aviation G36 LLC · Umatilla, FLS/N E-4019 N459TCN459tc LLC · Wray, COBuilt 1972 · S/N D-9328 N45AMThornburg Rocky R · White Hall, ARBuilt 1964 · S/N 21058475 N45BBSpeer Aircraft LLC · Evansville, INBuilt 1979 · S/N 421C0661 N45BVGrinberg Dmitry · Austin, TXBuilt 2004 · S/N 1007 N45DHMedic Choppers LLC · Springdale, ARBuilt 1969 · S/N TE-718 N45DSDcd Agriculture LLC · Franktown, COS/N 18503111

Back to AD 86-13-04 R3